1 2 Previous Next 15 Replies Latest reply on Dec 13, 2012 12:49 PM by Yonel Letellier

    number of days in month of future years

    Yonel Letellier

      Please I need to get the number of days for the months  of future years, ie, jan 2013 - Dec 2015.

       

      I have this formula to get the number days in the months in my database: DATEADD('month',1,DATETRUNC('Month,[Date])) - DATEADD('month',DATETRUNC('Month',[Date]). My data base have data from Jan 10 to Sep 12.

       

      I need to get the number of days for the months Oct12 - Dec 15.

       

      Thanks a lot

        1 2 Previous Next