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

thanks

You should find functions here to find the relevant dates:

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

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

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

Place this in the criteria

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

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


Brian