How to write this date comparison IF statement where it should exclude "Missing" labelled dates?

mwallman — Mon, 23 Jul 2018 15:49:32 GMT

Hello,

I have a dates table like this:

How can I write an IF statement where it is something like IF(Date1<=Date,ID)

But also to add a clause where it excludes dates from Date2 field where they are classified as "Missing"?

Re: How to write this date comparison IF statement where it should exclude "Missing" labelled dates?

sunny_talwar — Mon, 23 Jul 2018 15:51:33 GMT

May be this

If(Date1 <= Date2 and Date2 <> 'Missing', ID)

Or if Missing means null, then this

If(Date1 <= Date2 and Len(Trim(Date2)) > 0, ID)