Format Hour Function

[SchuhTL]

I am using the the hour function as follows:
hour({tablename.open_date}). I am using this in a chart to display calls that were opened by hour & every hour is diplaying 8.00, 9.00 etc...and I can't get rid of the trailing zero's. If I convert the formula to text and trim the zero's it does not display in ascending order. Please help!

 

[chelseatech]

You could use the Format string directly
ToText({tablename.open_date},"hh&quot

Look at the other date and time format strings for ToText in the help file. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm