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

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