How can i calculate week endings dates in access?

F

Fred

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.
 
D

David C. Holley

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)))
 
Top