Android Question Select .. Where Date .. (RDC MySQL)

[Anderson Linhares]

I am using RDC for access to MySQL and it is working fine. The problem is that when I use the SELECT passing filter parameter to a field of type date and return is empty. Any other type of field in the parameter works except the date type.
I already sent the parameter in the following example: '27 / 05/2018 'and' 2018/05/27 'and it will not. Using direct select in MySQL works.

 

[OliverA]

According to MySQL documentation (), the format should be 'YYYY-MM-DD', including the single quotes. If what you are saying '2018/05/27' works in your "direct select" test, then you need to include the single quotes with your date that your are submitting to jRDC, otherwise, you are not really doing the same thing (since you are using single quotes to delimiter your date in the "direct select", but you are not when submitting to jRDC).