ODBC - MS Query

Hi all, I’m using MS/Query and want to get table-data via ODBC from Navision (2.6). If I want to ask date-parameters from the user, I get “Conversion Error” everytime. Here my query: SELECT Sachposten.Lfd__Nr_, Sachposten.Buchungsdatum FROM Sachposten Sachposten WHERE (Sachposten.Buchungsdatum = ?) → For seeking “02. February 2002” I’ve tried to input “2002-02-01”, “2002-01-02”, “02-02-01”, “02-01-02” → same with dots and shlashes into the parameter-dialog Nothing works! Anyone who can help? Thanks

Try this SELECT * FROM NavisionDable WHERE DateField=‘311201’ Or SELECT * FROM NavisionDable WHERE DateField={d ‘2001-12-31’} ^^^^^^^^^^^^^^^^ Or SELECT * FROM NavisionDable WHERE DateFilter=‘010101…311201’ Business Applications Programmer Sertified Navision Developer SIA “Sintegra” Latvia

Sorry not Dable but Table Business Applications Programmer Sertified Navision Developer SIA “Sintegra” Latvia