How to create a time field
I have a text box within SSRS 2005, which contains an int some of the fields are like 10, 5, 22 etc.... I want to help in writing and expression that would format the text for it to look like a time value... so for example 00:10:00 00:05:00 00:22:00 i thought the following would work but it returns and #error# ="00:"+Fields!test.Value+":00"
November 1st, 2011 12:08pm
Hi Sam233, You are getting an error because you are trying to concatenate an integer with strings. Try: = "00:" + Format(Fields!test.Value,"00") + ":00" The second argument to the Format function specifies how you want the first argument formatted, in this case with leading zeros. Note: If your value is greater than 59, this example won't work, you'll have to use different logic. I hope this helps.DJAnsc
November 1st, 2011 12:38pm