Amount of Days in Quarter

user02685
user02685 Member
in Magic ETL

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?

Best Answer

  • user02685
    user02685 Member
    Answer ✓

    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)

Answers

  • user02685
    user02685 Member
    Answer ✓

    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)

Categories