return a date range

[aoswald]

What forumla do I use to return entries one week on either side of today's date:

thanks

 

[pbaldy]

You should find functions here to find the relevant dates:

http://www.pacificdb.com.au/Support/code_datetime.htm

 

[allan57]

DateAdd("ww", -1, Now()) = Minus one week
DateAdd("ww", 1, Now()) = Add one week

 

[aoswald]

allan57
do I just put that formula in the criteria field
if yes - it didn't work

 

[allan57]

Place this in the criteria

Between DateAdd("ww",-1,Now()) And DateAdd("ww",1,Now())

 

[Brianwarnock]

The danger of using Now() instead of Date() is that it adds time into the mix, Date() defaults to 00:00:00.


Brian