Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

143 0
Showing results for 
Search instead for 
Did you mean: 

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