TOPIC: SQL DateTime Selection via Parameter

I get Error Message "Datentypenkonflikt in Kriterienausdruck" s from the Access Adapter for the SQL Statement "select* from 041_S_Artikel WHERE ADate >= '$ABDATUM$' ". The source data look like 
The Read Adapter is configured like:

and the Parameter definition looks like

I've tried any combination of DateTime Formats, but the error message stys.
Whats going wrong?

Hi Mikel,

There is no need to post your question in the both (German/English) support forums simultaneous

For Microsoft Access databases you just have to surround your date with the crossbar “#” sign. For example

    Select * from [Table1] where fromdate >= #2020-02-01#

The date should be formatted as ISO format like “yyyy-MM-dd HH:mm:ss”. For more info please visit the post in the German Support Forum : Abfrage nach DATE/TIME einschränken

There is also a short example including a small Access test database available.