Calaculations Two Weeks Before

[adenwalker]

Hi,

I have a table which contains many fields of which one is a date field. How would i create a query so that it shows every record which is between the date the query is run and two weeks from the day the query is run?

Thanks

 

[trucktime]

Query

Try this:

In the Criteria Row of the Date Field in the Query put:

Between Date() And DateAdd('ww',2,Date())

Which shows the records with dates between the current date and the date two weeks from the current date.

In case you want the records for the past two weeks put:

Between Date() And DateAdd('ww',-2,Date())

 

[adenwalker]

it doesn't seem to work. It finds the date two weeks from today but nothing inbetween.

 

[trucktime]

Date

Hmm, it worked for me.

Perhaps you can post your db (without sensitive data) and I'll have a look.