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!

See my answer to your previous post;

Edited by rkrowland - 26 Jan 2012 at 1:04am

"The format of the date information is: 9/19/2011  10:13:12AM"

Is that the type of information you were looking for rkrowland? I saw you original post as well that you linked to, however, with the format of my field being so different than you had mentioned I (as you stated originally) was not successful.

Again, my biggest challenge that I am identifying at this time is that the time data that I have is in a 12 hour format so I when begin splitting the data it is not distinguished between am and pm. I end up with 12 data points instead of 24 in the end.

Sorry if I doing a poor job explaining this and thanks for everyone's help.