02-18-2016 06:31 PM
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.
Need further help from the community? Please ask a new question.