Skip to main content
Solved

Formula Query for null dates

  • January 11, 2022
  • 0 replies
  • 497 views

I'm trying to create a rich text button which will open a report where certain dates are null.  I've verified by running the report manually that the report does find results however when I use the rich text button I get no results.  I've tested in both the button and in the developer.quickbase.com site and have confirmed no results in both places - thus I'm positive it's something to do with my query structure.

The query I've passed is:
"{94.EX.8}and({24.XEX.''}or{25.XEX.''}or{70.XEX.''}or{71.XEX.''})"

Fields 24, 25, 70 and 71 are all Date fields and 94 is the related record.  What I'm trying to achieve is "Show me all results where any of the 4 date fields are not null".



TIA!



------------------------------
Jeremy Lahners
LeadBaller
------------------------------

Best answer by JeremyLahners

Just to close the loop on this - we found the issue.  "AND" and "OR" are case-sensitive.  Once we corrected those to be all-caps it worked fine.

------------------------------
Jeremy Lahners
LeadBaller
------------------------------
Jeremy Lahners LeadBaller
This topic has been closed for replies.

  • JeremyLahners
  • Author
  • Registered
  • Answer
  • January 11, 2022
Just to close the loop on this - we found the issue.  "AND" and "OR" are case-sensitive.  Once we corrected those to be all-caps it worked fine.

------------------------------
Jeremy Lahners
LeadBaller
------------------------------
Jeremy Lahners LeadBaller
Terms & ConditionsAccessibility statement