## Find Week within a Month

Solved
Frequent Contributor
Posts: 106

# 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

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: 106

## Re: Find Week within a Month

Thank you!.  It worked!

Frequent Contributor
Posts: 106

## 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 and locked.