Question about date in query

[Noreene Patrick]

I have a query that pulls # of employee occurrences in a date range...right now in my criteria line under occdate I have:

between date() and date()-180 (That pulls all occurrences for employee between today and 6 months ago)

I think what I need the criteria line to say is:

between [enter date] and "whatever enter date was" - 180

This way we can find out how many occ have occurred in a specific date range by only inserting one date and not having to count backwards 6 months.

Can you help me? Or is there a better way?

Thanks, Noreene

 

[Newman]

You almost gave the answer...
In the criteria line, write this:

between [Please enter date here] and [Please enter date here] - 180

You could also use:

between [Enter minimum date here] and [Enter maximum date here]

This would give the user the option of choosing its own range lenght.

 

[Noreene Patrick]

Thanks for your help.

Noreene