Integer to HH:MM:SS -- sql server reporting services

lucotc
7/2/2006 7:45:01 PM

Hi,
In SRS 2K, how can I take a field that is listed as an integer (say 60),
and make it look like 01:00:00 in the report? Is there a way to do this in
the Textbox Properties window using the Custom Format section?

lucotc
7/3/2006 5:15:02 AM

Found my answer in another thread:
=String.Format("{0:HH:mm:ss}",CDate("0:0:0").AddSeconds(Fields!*Value))

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Integer to HH:MM:SS