Alteryx Designer Desktop Discussions

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

Records with one date column after another date column

jly3292014
7 - Meteor

I am trying to find any records (from the sample data below) with DOCUMENT_DATE after RECORDING_DATE. After converting those two columns to date data type, I created a new column stating "IF [DOCUMENT_DATE]>[RECORDING_DATE] THEN 1 ELSE 0 ENDIF". However, I found no records. Please advise on how I can resolve the issue.

 

1 REPLY 1
brianfia
8 - Asteroid

@jly3292014  looking at your sample data, the Document Date is not ever greater than the Record Date.

 

Date_Format.PNG

Labels