Need Help on Parameter.Please.......

[ecugrad]

I have a StartTime and an EndTime Field both are DateTime data types. I have set-up a parameter using both. We have two shifts at work one that runs from 6:00am to 6:00pm and one that goes to 6:00pm to 12:00am. I want to report only on the 6:00am to 6:00pm shift. How do I set it up only to capture the times I'm looking for?

Thanks

 

[FoxG]

Hi,

Add something like the following to the record selection formula...

Time({DateTimefield}) >= time(06,00,00) and
Time({DateTimeField)) < time(18,00,00)

Geoff

 

[1963520]

Try this.
Click Format Section-->suppress button, and then put this code there.

StartTime= 6m and EndTime = 12:am