No. of Days

[#1]

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

[Anonymous]

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