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 r...
formula queries
  • JeremyLahners's avatar
    JeremyLahners
    3 years 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
    ------------------------------
JeremyLahners's avatar
JeremyLahners
Qrew Cadet
3 years 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
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years 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
    ------------------------------