First date of a week number?

[kalebson]

Hi Folks,

I use this to get a week number for a date range:

WeekNo: DatePart("ww",[Timestamp])

Is there a way that I could also get just the first date from that week number to appear in the query as well?

ie. if Week 1 is 3/1/07-3/7/07 the query would show 3/1/07 as well as week 1. TIA

 

[mhartman]

Date() - Weekday(Date()) + 1

Will give you the first day of the current week

Regards
Mark