5 Replies Latest reply on Oct 22, 2018 12:03 PM by chakradhar kakani

    calculate number of days in Month Dynamically (for incomplete month)

    chakradhar kakani

      Hello All,

       

      I'm trying to calculate no of days in month dynamically, for example (screenshot below) for month of sept i have 30 days and for Oct i have 31 days which is correct but as the current current month is not over, i want to show number of days that have passed in the current month dynamically along with the rest of months showing it number of days

       

       

       

      below is the formula i would appreciate if anyone can please provide possible solution or tweak it

       

      min(DATEPART('day', DATEADD('day', -1, DATEADD('month', 1, DATETRUNC('month', [Created Date])))))