dervive Week Commencing Date from any date?

M

Matt D Francis

Hi.

My Database contains a Date/Time field (MyDate) and it would be usefull if I
add a field in my Query that calculates the Week Commencing date for each of
these, using Monday as the Start date

e.g

MyDate = Week Commencing Date
10/10/2005 = 10/10/2005
11/10/2005 = 10/10/2005
18/10/2005 = 17/10/2005
21/10/2005 = 17/10/2005

etc

I've looked through the site but can find nothing on this.

Hoping someone can help.
 
M

Matt D Francis

Cheers, ended up using

WeekCom: [ReceiptDate]+1-Weekday([ReceiptDate]+6)

which seems to work well.
 
Top