Forum Discussion

FelicityPenderg's avatar
FelicityPenderg
Qrew Trainee
8 years ago

Two blank date fields coming up in report when have filtered for dates not equal

I have a report comparing two date fields. If they are not equal they should be present on the report. This is fine when both date fields are entered and different however when both date fields are bl...
FelicityPenderg's avatar
FelicityPenderg
Qrew Trainee
8 years ago
Thanks for this however I'm afraid this is not quite what I'm after. 

The above formula will get rid the entry if either of the dates are blank. I however am interested in these entries and only want  the entries with TWO blank dates to leave the report. 

E.g if I have a date 1 and date 2 and they are the same - not on report.
if i have date 1 missing and date 2 missing - not on report
if I have date 1 and date 2 missing - on report
if I have date 2 missing and date 1 - on report
if i have date 1 and date 2 but they are different - on report. 

Hopefully this makes more sense? 

Thanks again.