DateAdd()

[jeo]

I have a date field in my query and what I want is dates that match Now() + 14 days (doesn't matter working/holidays).
Is there a way to put DateAdd function of some sort in the criteria for this field?
DateAdd("d",14,[Date]) may be?
Thanks!

 

[Popolou]

Hey there,

I came across a similair issue the other day and resolved it using the "Between....And...." parameters.

For example, if you want to collect all the reciepts within the last 10 days i would use something like: -

Between Date() And Date()-10

Or, if you wanted to get a particular set of reciepts for a specific period, say between 2-3 months ago: -

Between Date()-30 And Date()-60

Also, pass by this site for a little more: http://www.fontstuff.com/access/acctut06.htm

Hope this helps!

Regards

Popolou

 

[jeo]

Thanks, this does help!