I've been trying to figure out how to create a formula that will show what CPE year a user's training is in. Similar to fiscal year, which I did try FY formulas that are out there to no avail, a CPE year runs from 3/31/xxxx to 4/1/xxxx. So, 3/31/2018 to 4/1/2019 would be considered CPE period 2018.
I've tried the following formulas ("Attended" is the date field I am working with):
The problem with either of those is that the CPE period is not renewing after the 3/31 date. So I have CPE period 2019 showing for an attended date of 5/23/2018 when it should be still CPE period 2018.
If anyone has any insight into what i am doing wrong or guidance please let me know.