Need to return NULLS from date field

Question

Hi.I am trying to pull all the invoices that have no date in the Date Delivered field. I tried this formula and it would not work.  IsNull([Date Delievered]) The filter condition did not work as it would not allow me to select blank if select "Is Not Equal TO"Thank you.------------------------------CMS ITOperations------------------------------

MarkShnierYou · Accepted Answer

:)np, just blank out that date where you see 05-03-2021------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

MarkShnierYou · Answer

Are you saying that you created a formula checkbox field to check for null against a date field type and it did not work. That does not sound possible.

or are you just trying a to filter a report where [Date Delivered] is equal to (blank)

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community