Hi there! My requirements for date range are more complex in that they include the day. So, I need “Month 1” to be 9/6/21 to 10/5/21 and “Month 2” to be 10/6/21 to 11/5/21, and so on. How would I go about doing that in Airtable?
Anyone following, I found a temporary solution using the formula @kuovonne outlined here.
It did seem that the automation was moving too quickly to calculate the complicate DATETIME_PARSE and DATEADD formulas. High chance I could be wrong though!
Hey @Justin_Barrett! Thanks for all your help over the last few months!
The automation works fine when testing, and when inputting values manually. The problem only occurs when records are being created by a form.
The automation is a fairly simply ...
