Forum Discussion

Qrew Cadet

3 years ago

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

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