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.
    • ArchiveUser
    • Registered
    • May 19, 2016
    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)
    • ArchiveUser
    • Registered
    • May 19, 2016
    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.
    • ArchiveUser
    • Registered
    • May 19, 2016
    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