Skip to main content
Question

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

  • January 17, 2013
  • 0 replies
  • 571 views
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.
    This topic has been closed for replies.

    • DavidHawe
    • Registered
    • January 17, 2013
    I am sure there are better ways but what I do is create a formula checkbox with this formula:

    If(IsNull([Date Field]),TRUE,FALSE)

    Use the checkbox to filter your report
    Can't you also just filter where [my certain date field] is not equal to the date (blank) - just blank out the date field.
    Hi.  Thanks for your quick reply!  Turns out I had to say [my datefield] >= (blank)  ; for some reason [my datefield] <> (blank) does not work.  This solution is so simple - I was looking for something more complicated!  But it might be clearer and useful to others to explicitly offer 'blank' or 'not blank' as filtering options. Thanks again.
    Hello.  This doesn't work for me.   I've tried blanking out the date as well as using >= (blank).  Any ideas?
    if you want a report where a date field is equal to or not equal to blank, then definately just blanking out the date field will work.

    ie where [my date field] is (blank ... just leave the space blank)
    Yeah, I did that.  Sounds like I have a system bug of some kind.  Thanks.
    it's very unlikely that it is a system bug.  Are you trying to filter a date field to not be blank on a table report?  is that the only filer on the rpeort?  Maybe your have other ANDs and ORs that are the real issue.
    Could be.  I'm looking for 2 conditions to be true.  [Owner Group] = MTRME AND [date field] is not (blank)
    i would like to filter a date field which are not empty .i tried the below formula 

    If(not IsNull([Date Field]),[Date Field ]) - not working 
    Is this a filter in a Report? if so, see my post above.

    Can't you also just filter where [my certain date field] is not equal to the date (blank) - just blank out the date field.
    [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.


    Terms & ConditionsAccessibility statement