Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Evie
6 - Meteoroid

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

2 REPLIES 2
DataBlender
11 - Bolide

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
6 - Meteoroid

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. 

 

 

Labels