This is in MySQL but the same concept should apply in Oracle. You need to format your date into string. In my case, I use the format "%Y-%m-%d" or "YYYY-mm-dd". You should input your parameter in the same format.If you need to compare 2 dates, you should prepare your statement first. You can use Common Table Expressions or subquery or temporary table in your dataset. I also sometimes use stored procedures in my dataset if more complicated preparation of data is needed. But most of the time, a simple common table expression or subquery will do the trick you needed. YMMV
HI Dawinpasco,
I need 2 conditions on the dates one an equality so it works if I convert the date to string but the other is less than or equal so I need to convert the parameter again to date. The problem here is that the query is correct but when I click on save it displays an error message "ORA-01861: literal does not match format string"
The trick is to do a preview before saving and it works like that