07-25-2013 04:56 AM
Week1 – week4
How do we determine that 8th of June is the first week of the months (as it is the 8th day )?
The reason of this is to determine the week range of the months.
I want to create a column that will tell me that a specific day of the months is either week1 –week4.
07-25-2013 05:28 AM
Will the following work for you:
date_test = '08JUN2013'd;
Further reading: 41732 - Determine the week number of a month