Forum Discussion

JeremyLahners's avatar
JeremyLahners
Qrew Cadet
3 years ago
Solved

Formula Query for null dates

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
------------------------------
  • 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
    ------------------------------

2 Replies

  • 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
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      Thank you for posting that. They really should enhance the formula editor to catch that problem.  It is tough enough to get the syntax correct for the queries without that kind of gotcha.

      ------------------------------
      Mark Shnier (YQC)
      mark.shnier@gmail.com
      ------------------------------