7 Replies Latest reply on Apr 27, 2018 3:42 AM by bhargavi chittibomma

    Days spent in current qtr

    bhargavi chittibomma

      Hi All,

      I am looking for a dynamic solution to get the days spent in current quarter till date which is 26.

       

      Currently I am calculating this by using DATEPART('dayofyear', today())-90. the value 90 is previous quarter number of days. I have to calcuate this based on todays date

       

      Any one help on this would be appreciated