Hey there. I’m trying to create a field that populates the fiscal year that a project is published in, as it’s different from the actual year.
So if the date of the project is between December 1, 2003 and November 30, 2004, it’s FY04. And so on for the following years ad infinitum. Any help would be appreciated; I’m having trouble with date formulas and I trawled through posts but couldn’t find a solution that worked for me.
Thanks in advance.