I’m using SharePoint Designer 2010 for a list workflow. I also have a second workflow and list that auto generates an “ID Number” in a column (using variables) with the current year and the next sequential number (FY2014-0002), which is added to each new record. A column titled “Prefix” contains the “FY.”
How do I change the current year to display a fiscal year, which starts Oct 1, and looks like FY15-0001 or FY2015-0001. I know how to change the year manually but I want it to auto-update on Oct 1.