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

    Dynamic field calculation using dates

    Deepika Siriah

      Hi,

       

      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!