Hi all,
I'm trying to work out this expression to display a value (FY25) if a date in a picker is between Oct 1 (24) - Sept 31 (25)
Works when I use the first part > than:
Solved! Go to Solution.
check your date format. You may wish to break it into moth / year
check your date format. You may wish to break it into moth / year
...worked it out...
IF(MONTH({DE:Event Start Date}) >=10 && MONTH({DE:Event Start Date}) <=12 && YEAR({DE:Event Start Date}) =2022
or (MONTH({DE:Event Start Date}) >=1 && MONTH({DE:Event Start Date}) <=9 && YEAR({DE:Event Start Date}) =2023),"FY23",
IF(MONTH({DE:Event Start Date}) >=10 && MONTH({DE:Event Start Date}) <=12 && YEAR({DE:Event Start Date}) =2023
or (MONTH({DE:Event Start Date}) >=1 && MONTH({DE:Event Start Date}) <=9 && YEAR({DE:Event Start Date}) =2024),"FY24",
IF(MONTH({DE:Event Start Date}) >=10 && MONTH({DE:Event Start Date}) <=12 && YEAR({DE:Event Start Date}) =2024
or (MONTH({DE:Event Start Date}) >=1 && MONTH({DE:Event Start Date}) <=9 && YEAR({DE:Event Start Date}) =2025),"FY25",
IF(MONTH({DE:Event Start Date}) >=10 && MONTH({DE:Event Start Date}) <= 12 && YEAR({DE:Event Start Date}) =2025
or (MONTH({DE:Event Start Date}) >=1 && MONTH({DE:Event Start Date}) <= 9 && YEAR({DE:Event Start Date}) =2026),"FY26",
IF(MONTH({DE:Event Start Date}) >=10 && MONTH({DE:Event Start Date}) <= 12 && YEAR({DE:Event Start Date}) =2026
or (MONTH({DE:Event Start Date}) >=1 && MONTH({DE:Event Start Date}) <= 9 && YEAR({DE:Event Start Date}) =2027),"FY27", "Unknown")))))