Forum Discussion
I tried the formula you posted and now I am getting:
Formula syntax error
A formula cannot end with an assignment to a variable declaration.
var text QUERY = "{145.OAF. ' " & ToText(FirstDayOfMonth([Month (First Day)])) & " '}AND{145.OBF. ' " & ToText(LastDayOfMonth([Month (First Day)])) & " '}AND{80.CT. ' " & "Qualified" & " '}AND{81.CT. ' " & "Water Trmt" & " '}";
I also tried it without ToText and got the same error.
------------------------------
Denis Rochat
------------------------------
1. Is the phrase "Water Trmt" actually in the data? verified
2. Is brravks49 the correct target table? verified
------------------------------
Denis Rochat
------------------------------
- DenisRochat3 months agoQrew Trainee
That was embarrassing.
Thank you for helping me with thus. Unfortunately, it still does not work.
------------------------------
Denis Rochat
------------------------------- MarkShnier__You3 months agoQrew Champion
If you would like I can have a quick look at your app. Please contact me directly by my email address in my signature line.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- DenisRochat3 months agoQrew Trainee
I sent you an email.
------------------------------
Denis Rochat
------------------------------