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.&nbsp; IsNull([Date Delievered])&nbsp;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------------------------------

markshnier__you · 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------------------------------

markshnier__you · 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
------------------------------

cmsitoperations · Answer

Hi Mark!!! :)The filter won't work as it doesn't give me the blank option that I was looking for.&nbsp;Hence why I need the formula. The Date Delivered is in a "Date" data type.&nbsp;------------------------------CMS ITOperations------------------------------

cmsitoperations · Answer

oooof! Thank you so much!! It works now!------------------------------CMS ITOperations------------------------------

Forum Discussion

Need to return NULLS from date field

4 Replies

Related Content

Color-coding a field returns field name

Text Formula Field returning Blank

check null dates

Running formula isNull vs Is not null

Is Not Null

Recent Discussions

Question about relationships

Summary Table Question

Google Search is back

Can I use quickbase actions within the same table?

Looking for Consultant: Add time tracking to existing task management app.