Time difference question...

[grom71]

Hi all,
I've created a report which I want to show all records from a database between 7pm last night, and 9am this morning.
My date/time field is such {14/03/2005 19.00.00} as an example.
Furthermore I planning to run the report automcatically every day at 9.30am using some scheduling software so I need it to get the correct records.
Does anyone have an easy way of doing this ?
Any help greatly appreciated....
Steve

 

[kskid]

With Crystal 8.5, I use the following if the field is a datetime field

{TABLE.DATE} IN [datetime((currentdate - 1),time(19,0,0)) TO datetime(currentdate,time(9,0,0))

Cheers,
-LW

 

[grom71]

thats great thanx