Can a request be submitted to correct the format of the drop-down so that ‘IN’ values match the shortdate values as the ‘=’ condition?
In contrast:
Hello Andrea,
Could you please let me know which data source you were using when you encountered this?
Also, what is the data type of the column, and what are your current settings for data type formatting?
My goal is to reproduce the issue on my end and verify whether it has already been documented.
Hi @nikola.stajkovic
The source is SAP HANA, and the data type for the column is timestamp.
Right now, the data type formatting is shortdate. I tried changing these options, but the WHERE clause still shows the shortdate and time for the IN condition. In the case of the =, the option changes seem to be working correctly.
Hi Andrea,
Thank you for providing the additional information. The issue has been documented accordingly.