Parameters in Select Expert

[richardtm]

For Crystal 8.5:

I have the select expert written to select those records in this date/time:

{casemain.schedcase_start_datetime} in {?frmdttm} to {?todttm}

This report is to run for a month at a time.

Can I keep this formala to choose those selected dates, but only those records where the time is between 0700 and 0800?

Short form: I want only those records between 7am and 8am for any amount of days I choose.

Thanks.

 

[kskid]

Try this

date({table.datetime}) in date({?frmdttm}) to date({?todttm}) and
time({table.datetime}) in time(7,0,0) to time(8,0,0)