Desktop productivity for business analysts and programmers

Find Week within a Month

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 104
Accepted Solution

Find Week within a Month

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


Accepted Solutions
Solution
‎02-18-2016 07:08 PM
Super Contributor
Posts: 490

Re: Find Week within a Month

What the expression you used?

 

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

 

Sample 41732: Determine the week number of a month

 

View solution in original post


All Replies
Solution
‎02-18-2016 07:08 PM
Super Contributor
Posts: 490

Re: Find Week within a Month

What the expression you used?

 

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

 

Sample 41732: Determine the week number of a month

 

Frequent Contributor
Posts: 104

Re: Find Week within a Month

Thank you!.  It worked!

Frequent Contributor
Posts: 104

Re: Find Week within a Month

Hi,

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

 

 

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 762 views
  • 1 like
  • 2 in conversation