Week of the month

Tatiane Oliveira · Aug 26, 2017 7:00AM

Summary

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

Martin van Donselaar · Aug 28, 2017 7:00AM

There is no such thing as 'week of the month' in a normal calendar .

Please be specific if you expect an answer.

Tatiane Oliveira · Oct 17, 2017 7:00AM

Examples:

01/28/2013, show fifth week of month.

10/17/2017, show third week of month.

Martin van Donselaar · Oct 30, 2017 7:00AM

You can provide 100 more examples, more examples do not make this more clear. Logic is what we need. Define 'week of the month'

Tatiane Oliveira · Nov 7, 2017 8:00AM

Examples:

01/28/2013, show 5.

10/17/2017, show 3.

Martin van Donselaar · Nov 8, 2017 8:00AM

This is a duplicate of issue

Please close this one

Robert Fighiroae-Oracle · Nov 28, 2017 8:00AM

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.