Forum Discussion

CMSITOperations's avatar
CMSITOperations
Qrew Member
4 years ago
Solved

Need to return NULLS from date field

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 w...
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    4 years ago
    :)

    np, just blank out that date where you see 05-03-2021

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
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's avatar
CMSITOperations
Qrew Member
4 years ago
Hi Mark!!! :)

The filter won't work as it doesn't give me the blank option that I was looking for. 



Hence why I need the formula. The Date Delivered is in a "Date" data type. 


------------------------------
CMS ITOperations
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    :)

    np, just blank out that date where you see 05-03-2021

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • CMSITOperations's avatar
      CMSITOperations
      Qrew Member
      4 years ago
      oooof! Thank you so much!! It works now!

      ------------------------------
      CMS ITOperations
      ------------------------------