increase the current date by X number of days

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

Guest

In my report i have a date that the customer must reply by. This date is the
current date + 14 days


=Date()+Day14

If the current date is 28 April 2005 then the above fumula does change the
month value eg it will go to 12 April 2005. I assume my code is wrong. can
anyone please help??
 
Day14 isn't a built-in Access constant, so you must have defined it yourself
somewhere.

To add 14 days to the current date, use Date() + 14, or DateAdd("d", 14,
Date())
 
Back
Top