Amount of Days in Quarter

user02685

Hi,

 

I'm trying to create a formula to count the total amount of days in the current quarter. Seems pretty simple, but can't seem to figure it out.

 

Any suggestions?

user02685

I figured it out on my own using the below formula

 

(CASE
WHEN QUARTER(NOW()) = 1 AND MOD(YEAR(NOW()), 4) = 0 THEN 91 /* First quarter leap year */
WHEN QUARTER(NOW()) = 1 AND MOD(YEAR(NOW()), 4) != 0 THEN 90 /* First quarter not leap year */
WHEN QUARTER(NOW()) = 2 THEN 91 /* Second quarter */
WHEN QUARTER(NOW()) = 3 THEN 92 /* Third quarter */
WHEN QUARTER(NOW()) = 4 THEN 92 /* Fourth quarter */
END)