Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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