Forum Discussion

DirkRuana's avatar
DirkRuana
Qrew Captain
6 years ago

Trying to create a isnull date filter on a report

Hi

Trying to filter a report by date.  Trying to review all records that do not have date information listed in date field (i.e. null content).

I tried: IsNull([Date Invoice Sent]) but something is wrong with my syntax.

Dirk
reports and charts
  • JustinTorrence's avatar
    JustinTorrence
    Qrew Cadet
    6 years ago
    There is no need to use a formula in the report.
    You could just apply a filter where:
    Date Invoice Sent "is equal to" BLANK