end of the week code?

[Finedean]

Hi All,
I have a field (in a query) called Start date.
Our company work days are Friday to Saturday. I am looking for a way to add a field called End date to generate the last day of the week date(which is Saturday).
For example:

Start day End day

05/15/2006 05/20/2006
05/17/2006 05/20/2006
05/19/2006 05/20/2006

05/24/2006 05/27/2006
05/25/2006 05/27/2006

thanks

Dean

 

[CautionMP]

Finedean,
7 is the default value for Saturday using the [tt]Weekday()[/tt] function so you could do this in your query: [tt][End Day]: [Start Date] + (7 - Weekday([Start Date]))[/tt]

Hope this helps,
CMP

(GMT-07:00) Mountain Time (US & Canada)

 

[Finedean]

Correction:
Company work day are Monday to Saturday.
Thanks
Dean

 

[ettienne]

Rats, I was just filling in a job application.

 

[Finedean]

Worked. Thanks cautionMP for your help.


Dean