This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...