Forum Discussion

BarryJakeBarryJ's avatar
BarryJakeBarryJ
Qrew Member
13 years ago

I need to filter a report based on an empty Date field. Can I do this?

I have a Calendar style report. I need to filter out records where a certain date field has been entered. Don't see that this is possible.

12 Replies

  • [date field ]not is equal to  date (blank) that's what i have implemented in the system but i wanted to try this report formula how it works and may i know the common reason why it is not working ??
  • If you want to filter the report on a date field being blank, then  you do not need to use a report formula

    Just make a filter on the report where

    [My date field] is equal to .... and blank out the date field.