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?