FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the existing examples of using the Access Adapter , which may answer your question: CSV import , generate test data , automated batch CSV import
  • Page:
  • 1

TOPIC:

SQL DateTime Selection via Parameter 8 months 1 week ago #3555

  • Michael Groß
  • Michael Groß's Avatar 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?
Attachments:

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

Last edit: by Michael Groß.

SQL DateTime Selection via Parameter 8 months 1 week 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.
The following user(s) said Thank You: Michael Groß

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.
  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en