Date Time SQL Queries: Formating Date Time Values for Access SQL in Delphi

in Delphi TIPS :: Ever got the awful "Parameter object is improperly defined. Inconsistent or incomplete information was provided" JET error? When you need to create a SQL query againts an Access database where a date (or a date time) value is used you need to make sure the correct formatting is used.

Read the full article to learn how to Format a Date and Time Value for the SQL Query

Related:

• How to add Leading Zeroes to a Number (Delphi Format)
• How to Auto Complete Date Value Input
• Data aware TDateTimePicker Delphi component