Converting all dates in a period to the first day of a following quarter

400 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I am trying to set up a reminder to do something on the first day of the second quarter after an event. So, for example, said event happens on February 6 (or January 27, or March 30, etc.), the reminder triggers on July 1. Likewise, if said event happens on October 20, the reminder triggers on April 1. I’m familiar with switch statements, but there has to be an easier way than writing out a switch for every day in a year (plus I also need to repeat the reminder for the third and fourth quarters, so that would be 3 times!) Hope that makes sense. Thanks!

0 Replies 0