date query (Probably simple)

[mrblonde]

Hi,

I need help with a query for a date field. The out put I'm looking for is any date within the last 21 days. I've been tinkering with the DateAdd Function but it won't take a negative number. Can someone guide me on the proper syntax?

 

[RickBerem]

Hi,

You should try

BETWEEN [Date1] AND DateSerial(Year([Date1]);Month([Date1]);Day([Date1])+21)

hope it helps! Salvatore Grassagliata

 

[mrblonde]

I got an invalid syntax at the ;

 

[RickBerem]

Hi,

Replace the ";" by the "list separator" of your system
it may be ","...

That should do it! Salvatore Grassagliata