|
Welcome,
Guest
|
See also the existing examples of using the
Access Adapter
, which may answer your question:
CSV import
,
generate test data
,
automated batch CSV import
TOPIC:
SQL DateTime Selection via Parameter 3 months 2 weeks ago #3555
|
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. |
SQL DateTime Selection via Parameter 3 months 2 weeks ago #3556
|
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.
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. |
