Invalid date input

Invalid date input errors occur when INSERT SQL statements do not use the correct Progress date format. Either of the following two syntaxes should succeed; the first is recommended for optimal compatibility.

ODBC Escape Syntax

{d 'yyyy-mm-dd'} 

For example,

{d '2001-05-15'}

Progress Date Syntax

'dd.mm.yyyy'

For example,

15.05.2001