14 Replies Latest reply on Jun 11, 2018 4:33 PM by Deepak Rai

    Dynamic field calculation using dates

    Deepika Siriah



      I want to create a dynamic field calculation using dates.


      First of all, I need to calculate date difference as DATEDIFF('year', 'dynamic current quarter end', [DOH])


      Is this possible that my quarter end is dynamic? 31/3/2018 for Q1 in 2018, 31/3/2019 for Q1 in 2019.



      Please let me know. Thanks!