SQL Server doesn't support empty dates, nor does ODBC driver or OLE DB provider. Consider using NULLs.

>I am using a universal date syntax when comes time to update dates in the table so I can benefit of something more easy to adapt to SQL Server and so on. However, the following doesn't work as this generates an invalid date.
>
>

>UPDATE Member SET Start={^0000/00/00} WHERE Numero=1
>

>
>How can someone update a date in the table in order to have it empty?