How can i calculate week endings dates in access?

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

Guest

Hello,
I was just wondering how it would be possible to obtain a field called
'week ending' which would give me a list of all the sunday's dates for the
coming year.
 
The following function will give the date for the SATURDAY following the
date supplied. You'll need to adapt it to obtain Sunday's date, wich
might be as easy as adding 1, but I'm not certain and don't have time to
play with it.

weekEndingDate = DateAdd("d", myDate, (7 - DatePart("w", myDate)))
 

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

Calculate Week of Year 7
Week ending date problems 6
week numbers 3
Excel Help with date adding formulas! 7
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Convert regular Date to Week Ending or Week Beginning Dates 4
Count records added in current week 3
Enter date in one cell, and the week ending date [Sunday] appears inthe "W/E" cell 3

Back
Top