Week Of number to an Actual Date

[skilche1]

Hi,

It's been a while since I've been here. I'm having a brainfart and need some help...

I have a table with a list of dates that pertain to other data in the table. In a query, I'd like to create a new column with a "Week-Of" date, with Sunday as the start of the week. I've scoured the net looking for a solution and was unable to find it.

Can some please help me out here?

Thank you!!!

 

[Brianwarnock]

A little confused are you asking for the Date of the sunday of the week the date is in ie for today 24/1/2010 you would want 21/3/2010 if so

Yourdate-weekday(yourdate,1)+1 or Yourdate-weekday(yourdate,2)

Brian

 

[skilche1]

Brian,

Sorry for the confusion, but yes, that was exactly what I was looking for. Funny thing... I was close to the "Yourdate-weekday(yourdate,1)+1". I just didn't have the (yourdate,1)...

Thanks a bunch, much appreciated.

 

[Brianwarnock]

Happy to help
Brian