Criteria

  • Thread starter Thread starter Aran
  • Start date Start date
A

Aran

Can someone tell me why this criteria will not work:

Between Date() and Date("m",3,Date())

I want to create a query that lists all records within 3
months of the current date.

Apologies for any stupidity

Many Thanks

Aran
 
Aran,

You need to use the DateAdd() function - try this ...

Between Date() And DateAdd("m",3,Date())

hth,
 
I am not sure but try one of these
Between Date() and Date(m; +3; date())
or
Between Date() and Date("m",+3,Date())

Jim
 
Sorry Cheryl is correct.

Jim
-----Original Message-----
I am not sure but try one of these
Between Date() and Date(m; +3; date())
or
Between Date() and Date("m",+3,Date())

Jim

.
Click to expand...
 
Back
Top