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

    No. of Days

    Kumar Pramod

      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