Criteria

[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

 

[Cheryl Fischer]

Aran,

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

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

hth,

 

[Jim/Chris]

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

 

[Jim/Chris]

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

.