Add 7 Days to Todays Report Date (1 Viewer)

access2010

Registered User.
Local time
Yesterday, 16:41
Joined
Dec 26, 2009
Messages
1,021
Could I please receive assistance in having an automatic date added to our MsAccess 2003 report?

The report date would be 7 days after today.

Thank you.
Nicole
 

Attachments

  • To-day_Plus_7.mdb
    212 KB · Views: 31

jdraw

Super Moderator
Staff member
Local time
Yesterday, 19:41
Joined
Jan 23, 2006
Messages
15,379
No data source, no accompanying info?

ReportDate = Date +7

?Date +7
16-Feb-24
 

ebs17

Well-known member
Local time
Today, 01:41
Joined
Feb 7, 2020
Messages
1,946
7 days after today
Code:
DateAdd("d", 7, Date())
This is a bit more detailed and is also suitable for time periods other than days.
 

Users who are viewing this thread

Top Bottom