Date - 7 Days

[gselliott]

I want to set up a query where i can search for all records with the date that is one week away from the actual date.

So if the date is 7/11/03 the query will display all records from 01/11/03 upto today.

Can any help please?

Thanks in advance!

 

[Mile-O]

Between DateAdd("d",-7, Date()) And Date()

 

[gselliott]

Thanks for your help again Mile-O-Phile it is much appreciated it worked a treat!

 

[Shepps]

just did a search and found this, its what i need, but im not sure how to use it? where does it go? I need it +7 days tho.

Cheers

 

[o1110010]

just did a search and found this, its what i need, but im not sure how to use it? where does it go? I need it +7 days tho.

Cheers

it's an expression. create a query with the desired fields you wish it to include, then in your date field's criteria area.. throw that in there. good luck.

 

[Shepps]

DateAdd("d",7,[Forms]![teste]![CPR retrain])

so that CPR retrain = the date. that works, but only if i put the date in the table -7. I.e if i was looking for the 12/12/2001, i need to put in the 05/12/2001 for it to find anything. I want a range from the date entered, upto a week after it. I dunno how to get that criteria above working with the []'s