1 Reply Latest reply: Dec 10, 2015 1:36 AM by balraj ahlawat RSS

    No. of Days

      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?