How can i calculate week endings dates in access?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred - 02 Mar 2005 13:29 GMT

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.

Reply to this Message

David C. Holley - 02 Mar 2005 15:28 GMT

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

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

Reply to this Message