>>Pass it as parameter and you should have no problems at all:
>>
>>ldDate = DATE()
>>lcSql = [INSERT INTO MyTable (MyDateTimeField) VALUES (?m.ldDate)]
>>
>True. But if you would want to convert it for whatever reason, what format should we use?
>
IMO, this conversion of values into a string which is then sent to SQL Server leaves the door open for SQL Injection Attacks. Passing parameters is safe. No user input "sanitizing" required, either.