ODATA date Filter Query to MySql does not return a result

[jevaun-bcmg]

ODATA Filter query to MySQL does not return any results.

Created_On is the column name and here is what i have tried:

• Created_On eq 2022-04-26T00:00:000Z
• Created_On eq 2022-04-26
• Created_On eq formatDateTime(utcNow(), 'yyyy-MM-ddT00:00:00Z')
• Created_On eq utcNow('yyyy-MM-ddT00:00:00Z')

Attempted both queries with and without '' single quotes. Does not return error but doesn't return results.

The MySql server is linked to power auto via on premise gateway.

I am able to successfully execute filter queries on other string and integer columns, my only issue is filtering by date.