12 Replies Latest reply on Apr 19, 2018 12:37 PM by bhargavi chittibomma

    Calculate number of days in quarter based on today date

    bhargavi chittibomma

      Hi,

      I am trying to calculate number of days in quarter based on today's date

       

      Ex:

      if ([Current Quarter])="1" then "90"

      elseif ([Current Quarter])="2" then "91"

      elseif ([Current Quarter])="3" then "92"

      else "94"end

       

      this helps me in showing current quarter number of days. But this in string format.

       

      My requirement is to divide number of days in current quarter based on today() date.

       

      Can any one help me on this..?

       

       

       

      Thanks