Applying different exchange rates for different date periods - ( nested IF function )

[Evie]

Hello 

Alteryx accepts my expression below within the Exchange Rate field, but only applies the first value ( 0.65 ) and only for the FULL date period.  What am I doing wrong?

IF
[Date] >='01/01/2016' and [Date] <='28/03/2016' Then 0.65

ELSEIF
[Date] >='01/04/2016' and [Date] <='29/08/2016' Then 0.68

Else
0.78

ENDIF

Many thanks 

Evie

[DataBlender · Accepted solution]

Hi @Evie

Try formatting the date in your filter as YYYY-MM-DD:

IF
[Date] >='2016-01-01' and [Date] <='2016-03-28' Then 0.65
ELSEIF
[Date] >='2016-04-01' and [Date] <='2016-08-29' Then 0.68
Else
0.78
ENDIF

[Evie]

Yes that worked!  Thanks :)

So just to note that if the "Date" within my sheet is 01/01/2016 then to change it in the function as YYYY-MM-DD.