By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,877 Members | 1,064 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,877 IT Pros & Developers. It's quick & easy.

Add a year plus a week to a date in a report

P: 2
I have written a simple membership database which prints cards using a report with an expiry date on. The expiry date should be the Date Issued field plus one year and one week.

I can add 53 weeks to this date using =DateAdd("ww",53,[Date Issued]) but this doesn't add exactly one year plus one week e.g. printing the card on the 20 April 2007 it returns the date 25 April 2008 and not 27 April 2008 (20 April 2008 plus 7 days) as I require.

Any help would be much appreciated, David
Apr 20 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
I have written a simple membership database which prints cards using a report with an expiry date on. The expiry date should be the Date Issued field plus one year and one week.

I can add 53 weeks to this date using =DateAdd("ww",53,[Date Issued]) but this doesn't add exactly one year plus one week e.g. printing the card on the 20 April 2007 it returns the date 25 April 2008 and not 27 April 2008 (20 April 2008 plus 7 days) as I require.

Any help would be much appreciated, David
Try

=DateAdd("ww", 1, (DateAdd("yyyy", 1, [Date Issued]))

OR

=DateAdd("d", 7, (DateAdd("yyyy", 1, [Date Issued]))
Apr 21 '07 #2

P: 2
Many thanks, it works a treat.

David
Apr 24 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
Many thanks, it works a treat.

David
You're welcome
Apr 24 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.