We have a field called, "Reporting Date" and I am having trouble creating a calculated field to return whether it is Year7 or Year8.
If 'Reporting Date' is between 2/9/2018 and 2/8/2019 then it is Year7. 2/9/2019 to 2/8/2020 would be Year8.
This is the formula I have right now.
=IF(AND([Reporting Date]>"2/8/2018",[Reporting Date]<"2/8/2019"),"Year7","Year8")
I didn't get any syntax error but I have documents that are in between those dates and also documents that are after the dates. However, I am getting only Year8s or something only Year7s when I was playing around with it.
What did I do wrong here...?!