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.
@jly3292014 looking at your sample data, the Document Date is not ever greater than the Record Date.