Date expressions

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.
 
D

David F Cox

The quick version, with the rest in Help under DateAdd function:-

BETWEEN Date() and DateAdd("..., Date(), ...)
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Todays Date + 3months 3
between date and dateadd query 6
query sql needed 1
Error on Query with DateSerial() 0
Problem with between date function 2
Month, DATE, Week 7
Help with relative date 3
Query - date field 7

Top