Finding Saturday from a week number

[Maverick_777]

Good morning all,
Maybe one of you could assist me.

I have an Access report where I have a field which shows the week number based on a date in a column.

THe control source is ="Week " & Format$([Install Date],"ww yyyy")

This returns the week number. What I want to do is see if I can modify this to show the Saturday's date for that week number.

Any thoughts would be greatly appreciated...
Thanks in advance...

 

[gwiz]

Good morning all,
Maybe one of you could assist me.

I have an Access report where I have a field which shows the week number based on a date in a column.

THe control source is ="Week " & Format$([Install Date],"ww yyyy")

This returns the week number. What I want to do is see if I can modify this to show the Saturday's date for that week number.

Any thoughts would be greatly appreciated...
Thanks in advance...

To get the Saturday of that week, you could use: DateAdd("d", 7 - Weekday([Install Date]), [Install Date])

 

[Maverick_777]

Thanks Gwiz. that brought about what I was looking for.

Thanks so much.