Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Help with expression

Avatar

Level 3

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
1 Accepted Solution

Avatar

Correct answer by
Level 6

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 6

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

Avatar

Level 3

...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}>=&& MONTH({DE:Event Start Date}<=&& 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}>=&& MONTH({DE:Event Start Date}<=&& 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}>=&& MONTH({DE:Event Start Date}<=&& 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}>=&& MONTH({DE:Event Start Date}<= && 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}>=&& MONTH({DE:Event Start Date}<= && YEAR({DE:Event Start Date}=2027),"FY27""Unknown")))))