Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a Load Script like below:
Month(weekend(CanonicalDate)) as MonthPeriod,
Date(MonthStart(weekend(CanonicalDate)),'MMM-YY') as MonthPeriod1,
These script gives me a monthperiod like:
Example: 1) October month count: from sep 28th to Oct 25th.
2) November month count : from oct 26th to Nov 29th.
How can i get the # of days for the month according to the above format?
Thanks,
Pramod
try what I have already suggested you on your another thread:
Custom MonthStart and MonthEnd
I was having same scenario and sorted it in this way