Alteryx Designer Desktop Discussions

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

Date Comparsion

Longdaica
7 - Meteor

Hi there please help me

 

My date format is YYYY-MM-DD in Vw_string

 

I did the formula on [UA_START_DATE]  and both  [UA_START_DATE] =  [FA_START_DATE] are 2017-01-01

 

IF [UA_START_DATE] >  [FA_START_DATE] then 1 ELSE 0 ENDIF

 

 

Somehow it gave me  0  as a result

2 REPLIES 2
Longdaica
7 - Meteor

I changed it to Date format, still cannot do the comparison properly 

LordNeilLord
15 - Aurora

Hey @Longdaica

 

An example of the data would be a massive help

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

Labels