Discussions

 View Only
  • 1.  Formula Query for null dates

    Posted 10 days ago

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


  • 2.  RE: Formula Query for null dates
    Best Answer

    Posted 10 days ago
    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
    ------------------------------



  • 3.  RE: Formula Query for null dates

    Posted 10 days ago
    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
    ------------------------------