user02685 Member

Comments

  • 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…