Week of the month
Hello,
I need get the week of the month.
Example: 28/01/2013, shows 5 week.
I'm using the Analysis, in Business Intelligence of Sales Cloud.
Regards,
Tatiane
There is no such thing as 'week of the month' in a normal calendar .
Please be specific if you expect an answer.
Examples:
01/28/2013, show fifth week of month.
10/17/2017, show third week of month.
You can provide 100 more examples, more examples do not make this more clear. Logic is what we need. Define 'week of the month'
01/28/2013, show 5.
10/17/2017, show 3.
This is a duplicate of issue
Please close this one
SELECT TO_CHAR(SYSDATE,'W') FROM DUAL;
WW+ - Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.
W+ - Week of month (1-5) where week 1 starts on the first day of the month and ends on the seventh.
