Nice one Nathan. You can also use the following formula in a single field if you’re happy with just returning the digits of the fiscal year (without the ‘FY’).
IF((DATETIME_FORMAT(Date, 'MM'))>6,((DATETIME_FORMAT(Date, 'YY'))+1), ((DATETIME_FORMAT(Da...
Hey Erika,
Little late to the party but thought I’d reply for the books as I just figured this out.
Essentially, you use DATETIME_FORMAT to get the month and calendar year as numerals and then a simple IF to return the calendar year if month is less ...
Hey Tonyska,
Super late but just stumbled upon this and think I have a solution.
If you’re on a Pro plan you can use the .CSV Import block to turn your Google Sheets into workable Airtable data. Just export as .csv from Sheets and import back into Ai...
