Where list on date fields

Kinetic ERP
1

Trying to get this where list on two date fields but staking out. Am I doing something wrong?

image

tried wrapping the value in single quotes but that didn’t seem to work either.
Can I get a second pair of eyes on this. I am banging my head against the wall and it is starting to hurt. Thank you in advance for your help.

2

Add the single quotes around it all, including the ? and then test it with Dev Tools to see what it’s actually doing. Check the network payload.

1 Like
3

image
image1328×379 17.3 KB

This seems to be the error I am getting, but I am not sure what it means.

4

Does that query run in the designer?

5

Yes, it does. The network response is a bad sql statement

image
image702×692 14.4 KB

6

And the error is the same one that I posted a few posts ago.