- Posts: 1
SQL DateTime Selection via Parameter
- Michael Groß
- Topic Author
- Offline
- User
Less
More
4 years 7 months ago - 4 years 7 months ago #3555
by Michael Groß
SQL DateTime Selection via Parameter was created by Michael Groß
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?
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?
Attachments:
Last edit: 4 years 7 months ago by Michael Groß.
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
4 years 7 months ago - 11 months 3 weeks ago #3556
by FlowHeater-Team
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.
Replied by FlowHeater-Team on topic SQL DateTime Selection via Parameter
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.
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.
Last edit: 11 months 3 weeks ago by FlowHeater-Team.
Please Log in or Create an account to join the conversation.
Time to create page: 0.263 seconds