Find Week within a Month

[sdang]

Hi all,

In Query Builder I have PlayDayDate in this format:  15FEB2016:00:00:00.  I want to create a new calculated column to find out the week within the month of February that PlayDayDate is in. The output value should be 3 as  '15Feb2016' lands in week 3 of February, not 7 like SAS has given.

Thanks

[mohamed_zaki · Accepted solution]

What the expression you used?

  week=intck('week',intnx('month',date,0),date)+1; 

Sample 41732: Determine the week number of a month

[sdang]

Thank you!.  It worked!

[sdang]

Hi,

Thank again.  I use the expression you've given me:

week=intck('week',intnx('month',date,0),date)+1;