4 Replies Latest reply on Oct 22, 2018 12:24 AM by mausami sharma

    How to write date range dynamic in calculated field.(countd(IF [Posting Date]>=DATE("09/01/2017") and [Posting Date]<=DATE("08/31/2018") then [Vendor] else null end)

    mausami sharma

      Hello All,

       

      I have a expression which i want to make it dynamic.

       

      (countd(IF [Posting Date]>=DATE("09/01/2017") and [Posting Date]<=DATE("08/31/2018") then [Vendor] else null end)

       

      How can i write this expression so that i dont need to update it every month.

       

      Thanks

      Mausami