5 Replies Latest reply on Mar 6, 2018 10:07 AM by james.diaz

    Formula to identify last day of month

    Varun P

      below formula identifies the last day of every month:
      DATEADD(‘day’,-1,DATEADD(‘month’,1,DATETRUNC(‘month’,[Date]))) 1}
      Can anyone explain what exactly each above words in formula do/ functions ?

       

      and is above formula correct ?