Records with one date after the other

[jly3292014]

I am trying to find any records (from the sample data attached) 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.

[IraWatt · Accepted solution]

Hey @jly3292014,

First thing is Id make sure your dates are of Date datatype before comparing them like this:

Secondly I'd say that all your Documents dates are before the recording date so all 0's is correct

HTH,

Ira

[DataNath · Accepted solution]

This should work. I had to add another record to the bottom that would satisfy this, as the dates provided all returned a false from your check:

[binuacs · Accepted solution]

@jly3292014 Another way of doing this with the Multi-Field formula