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
Free Windows Admin Tool Kit Click here and download it now
November 1st, 2011 12:38pm