Help with expression

[AndyKent]

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:

IF(({DE:Event Start Date}) >= 01/10/2024, IF(({DE:Event Start Date}) <= 30/09/25, "FY25", "-"))

But not when I add the second section < than.

Also tried the following:

IF(({DE:Event Start Date}) >= "01/10/2024" && ({DE:Event End Date}) <= "30/09/25", "FY25", "-")

Any ideas out there?

Andy

[GrahamJarrett · Accepted solution]

check your date format. You may wish to break it into moth / year

[AndyKent]

...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")))))