Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.
SOLVED

Date Comparsion

Highlighted
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

Highlighted
Meteor

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

Alteryx Certified Partner

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