Need to pull between today's date minus a week???

[mrskyun]

Hi guys,

I am trying to pull between the current date minus a week in my Access query and I do not know what formula to use. Please help???

 

[pbaldy]

Try the DateAdd() function.

 

[mrskyun]

I'm sorry how would I use that function?

 

[pbaldy]

I'd start by looking in help to get the syntax. If you didn't know, you can use the Date() function to get the current date.

 

[mrskyun]

I know how to get the current date I'm just not sure how to grab a range between the current date and the date 7 days past :S I apologize for my noobness...

 

[pbaldy]

A criteria of

Between DateAdd(...) And Date()

filling in the DateAdd() arguments of course.

 

[bob fitz]

Perhaps something like:
Between DateAdd("d",-7, Date()) AND Date()

 

[mrskyun]

:S I just tried Between DateAdd("d",-7, Date()) AND Date() but it says invalid string... the field that I am trying to write this criteria has dates like "1/1/2014".

 

[pbaldy]

If the field is text rather than date/time, you'll have issues, and the above wouldn't work.