Start Free Trial

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
Top Solution Authors