Save yourself the trouble. If you specify the date literal as YYYYMMDD, SQL Server will always interpret it correctly.
-Mike
>Hi all,
>
>The question i have is:
>When i'm creating a string to use at a SQLEXEC(), i'm having a problem with dates, because SQL Server receives it from another format. Imagine this code:
>
>lcInstruction = "Update clients set date_payment = '" + ttoc(ldDatePay) + "' where codCli = ....."
>
>When i do a SELECT instruction from my table, i see that the date value is "2000-08-09", but the value of my update is wrong. And, to help wprst a little bit, TTOC() function doesn't give a dam with the SET DATE ...
>
>I know i could solve it with a remote view, but i don't want! I just want to make an update operation.
>
>Is there a way to get the date format from the SQL S.(and i could prepare the right instruction)?
>
>Any ideas?
>
>Thanks,
>
>Ric