Forum Discussion
- DavidHaweQrew TraineeI 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 - QuickBaseCoachDQrew CaptainCan't you also just filter where [my certain date field] is not equal to the date (blank) - just blank out the date field.
- BarryJakeBarryJQrew MemberHi. 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.
- ArchiveUserQrew CaptainHello. This doesn't work for me. I've tried blanking out the date as well as using >= (blank). Any ideas?
- QuickBaseCoachDQrew Captainif 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) - ArchiveUserQrew CaptainYeah, I did that. Sounds like I have a system bug of some kind. Thanks.
- QuickBaseCoachDQrew Captainit'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.
- ArchiveUserQrew CaptainCould be. I'm looking for 2 conditions to be true. [Owner Group] = MTRME AND [date field] is not (blank)
- PoojaManickamQrew Memberi 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 - QuickBaseCoachDQrew CaptainIs 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.