I have a report that I need to pull records for time range.
I am using Crystal XI
incident.date = date&time dd/mm/yy hh:mm:ss
incident.date holds both the date and timestamp of the record.
I need the formula to look in the incident.date field and then look at the time stamp in 24hr time and if the time is between 17:00:00 and 07:00:00 then return records.
I have tried to use the cTime and Istime but no success
Any help greatly appreciated
Castaldo
Clyde FD
I am using Crystal XI
incident.date = date&time dd/mm/yy hh:mm:ss
incident.date holds both the date and timestamp of the record.
I need the formula to look in the incident.date field and then look at the time stamp in 24hr time and if the time is between 17:00:00 and 07:00:00 then return records.
I have tried to use the cTime and Istime but no success
Any help greatly appreciated
Castaldo
Clyde FD