How to format a time field, please?

[davortsan]

Hi mates,

 I have a dataset in a telerik report. The dataset returns a time column. I would like to use the Format function to show it in hh:mm format. If I use Format('{0:hh:mm}', Fields.CreationTime), there is an exception. Currently, I'm using a "manual" transformation, using Fields.CreationTime.Hours + ":" + Fields.CreationTime.Minutes but this is not a solution for me because if the CreationTime is 12:00, the report shows 12:0. I would like to use the Format function OR show the minutes using two digits. How could I resolve my issue, please?

 Thanks a lot in advance.

 Cheers.

David Ortega

[davortsan]

Hi mates,

I've found a similar issue and this resolved my problem:

    Fields.CreationTime.Hours.ToString("N0") + Fields.CreationTime.ToString("\:mm")

Thanks a lot for your help.

Cheers.

David Ortega.

[Davi]

I had the same problem.  I figured out one solutions is escape the second ":"

Format('{0:hh\:mm}', Fields.CreationTime)  

[Silviya]

Hello Davi,

I'm happy that escaping the ":" resolved the issue.

Still, for detailed information about date and time format specifiers can be found in Standard Date and Time Format Strings and Custom Date and Time Format Strings articles.

Best Regards,
Silviya
Progress Telerik

[Brajalal]

Try this
=Format("{0: h\:mm tt}",Fields.date)