-
Michael Groß
-
Topic Author
-
Offline
-
Posts: 1
-
-
|
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?
|
Please Log in or Create an account to join the conversation.
Last edit: by Michael Groß.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
|
Please Log in or Create an account to join the conversation.
|
Time to create page: 0.152 seconds