Date Criteria

[jonnymenthol]

If I run a query from say 1st February 2005 to Today's Date, I put a criteria of "Between 01/02/05 and Date()"

This works fine.

However, I want to run this alongside another query which provides the same data for the same period last year.

So what would the command be if I wanted the same for last year?

For example, If I run it today, the period covered by last year would be "01/02/04 to 03/03/04"
If I run it next Friday, the period I'd want covered from last year would be "01/02/04 to 11/03/04"

Does this make sense ?

If not, please let me know and I'll try to provide better examples.

Cheers.

J.

 

[jonnymenthol]

Cheers I'll give that a go.

J.