AddDate (1year) function

  • Thread starter Thread starter Steve Schneider
  • Start date Start date
S

Steve Schneider

I'm trying to get a query to add exactly one year to a
date format of 09/26/03. I've tried AddDate("d",365,
[DateJoined]), but it doesn't always calculate to exactly
the same date. (e.g. 10/1/03 becomes 09/30/04) I'm sure
it's something simple, but nothing's working at the
moment. Thank you.
 
Steve Schneider said:
I'm trying to get a query to add exactly one year to a
date format of 09/26/03. I've tried AddDate("d",365,
[DateJoined]), but it doesn't always calculate to exactly
the same date. (e.g. 10/1/03 becomes 09/30/04) I'm sure
it's something simple, but nothing's working at the
moment. Thank you.
Click to expand...

It's DateAdd, not AddDate, and you can add 1 year instead of 365 days and you will
get an exact return (even accounting for leap years).

DateAdd("yyyy", 1, [DateJoined])
 
Back
Top