v.10- Dividing a date/time stamp

[LIMS2LIMS]

Hi,
I have a date/time stamp that I want to seperate. I need to report on the activity of the users for the past 4 weeks, graph it to show what time of day the activity is at a high and at a low. I have to use the date/time field for my x and y axis. Any help would be greatly appreciated.

 

[Madawc]

Do a pair of fomula fields, Date({your.datetime}) and Time({your.datetime}).

It helps to give your Crystal version, since newer versions have extra options, and some extra problems. My workplace is currently upgrading from Crystal 8.5 to Crystal 10, both using databases created by SQL 8.

Madawc Williams (East Anglia, UK)

 

[LIMS2LIMS]

Thanks for the help. Please note the "v.10" in the title. Thats the version of crystal. Sorry if I wasnt clear enough. However, I neglected to give the db. SQL 2000 sp3.

Thanks again!!