Countback Dates

[digs]

We have a contracts db with a end date field for each contract. For redundancy purposes we need to go back 12 weeks from the end date. What I'd like is to create a query that will display the last 12 weeks from the end date of a contract. Does anyone know if this can be done.

 

[namliam]

To go back 12 weeks simply take the end contract date and substract 12*7

[End date] -12*7

As simple as that....