6 Replies Latest reply on Aug 13, 2017 11:17 PM by ramanjaneyulu.golla

    Number of days in Current Month

    ramanjaneyulu.golla

      Hi ALL,

       

      Could you please share your idea(s) or possible solution(s) on how to find no.of.days in the Current Month?

       

      I have been trying this:

       

      DATEADD('month',1,DATETRUNC('month,[Order Date])) - DATEADD('month',DATETRUNC('month',[Order Date])

       

      but shows error..

       

      Thanks in Advance!!

       

       

      Regards,

      Ram