community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Date Comparsion

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

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