Date expressions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would be grateful for some help in writing a date expression in a query and
report (Access 2003).

I need the query/report to display all records where the due date is between
todays date plus 1 day". "Todays date plus 1 week". " Todays date plus 1
month". "Todays date plus 1 year" etc.

However, I don't want to type in dates.

Many thanks for your help.
 
The quick version, with the rest in Help under DateAdd function:-

BETWEEN Date() and DateAdd("..., Date(), ...)
 
Many thanks David! problem sorted.

David F Cox said:
The quick version, with the rest in Help under DateAdd function:-

BETWEEN Date() and DateAdd("..., Date(), ...)
Click to expand...
 
Back
Top