1 Reply Latest reply on Jun 12, 2014 10:31 AM by philmodjunk

    Regarding No of Days In Month

    samarthmkt

      Title

      Regarding No of Days In Month

      Post

           Dear sir,

           Can I get the calculative script of getting the no. of days value of particular month.

      sal.PNG

        • 1. Re: Regarding No of Days In Month
          philmodjunk

               Day ( Date ( 2 ; 0 ; 2012 ) )

               will return the number of days in January, 2011.

               So as long as you have a number for the month and the year, this is simple: Day ( Date ( MonthNumber + 1 ; 0 ; year ) )

               If you want to select the month by name, you may need to use this calculation to get a month number from the month name:

               Ceiling ( Position ( "JanFebMarAprMayJunJulAugSepOctNovDec" ; Left ( MonthName ; 3 ) ; 1 ; 1 ) / 3 )