Hey all - Crystal newbie here. Please have patience :)
I have a report I need to break down by time of day.
For example, looking at a months worth of data I want to determine the volume of data that came in at 7am, 8am, 9am, etc..
My
challenge that I am currently stuck on is that the date/time data I
have is AM/PM not military. The way I have it setup currently is using split:
split(ToText ({time.field}),':')[1]
With this, however, 7am is no different than 7pm. I tried Crystal's help and
found DTSToTime but this doesn't appear to be a valid function in 2008.
The format of the date information is: 9/19/2011 10:13:12AM
Any thoughts on how to sort this data based on time of day best?
Thanks again for your help - greatly appreciated!