Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Chart

SQL DateTime Selection via Parameter

  • Michael Groß
  • Topic Author
  • Offline
  • User
  • User
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?
Last edit: 4 years 7 months ago by Michael Groß.

Please Log in or Create an account to join the conversation.

More
4 years 7 months ago - 11 months 3 weeks ago #3556 by FlowHeater-Team
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.

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
FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.