Convert Date to week

  • Thread starter Thread starter SF
  • Start date Start date
S

SF

Hi,

I have Sv_Date. I want to display W1, W2, W3, W4. Instead the following
DatePart("ww",[Sv_Date]) would give me week 38 if Sv_Date = #9/17/2006#.

What I want is week of each month eg W1, W2, W3 AND W4

SF
 
First we need to know what you mean by week. Are you talking full weeks? What
about 1-Sep-06 which was on a Friday - which week would that be in? 1-Aug-06
was on a Tuesday and 31-Aug-06 on a Thursday. Which weeks for them?
 
Untested but should work:
MonthWeek=DatePart(["ww",[Sv_Date])-DatePart("ww",DateSerial(Year([Sv_Date]),Month([Sv_Date]),1))+1

Regards/JK
 
Back
Top