date/time range across two days

[AP186]

Currently using Crystal Reports 8.5
If have two fields within a database (date) and (time)which are populated by wifi scanners. As a working shift covers from 21:00 to 05:00 the following day. I need to be able to produce a date/time range so I can analyse the number of scans across shifts. Any assistance will be greatfully appreciated

 

[Madawc]

If you used DateAdd to subtract five hours from the date-time for that shift, it would all come within a single day, which I assume is the problem. This would be somethign like

if @shift3 then
DateAdd("h", -5, {your.datetime}
else {your.datetime}

You could analyse the resultant values for all shifts - I assume you have some way of recognising them, a way to define @shift3.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10