Updating a SQL Date field from a navision date field.

rfernandes

i use the format, and after accessing the SQL Table and see the date format in there (DD-MM-YYYY), after de update, the field become with a diferent date that i wat...a undefined date.

for example, i move 02-02-2002 to the date field, and after the update it becomes 25-09-1905 ... or someting .. .

can someone help me on the formating the navision date field to the SQL recognize?

tank you.

kine

Please, can you be more specific? Describe what you are doing, how you are doing that, why you are doing that. I am not sure what you are doing...

Thanks.

rfernandes

hello kine,

'm updating a date field on a SQL external DB.

in the Invoice form, wen i register , i update that external SQL DB with the invoice "posting nr" and "posting date". but i can't update the date correctly..
i have to format it .. but i can't find the away to do the UPDATE...
the number is easy, and its doing fine.

can you help me on this?

kine

See http://msdn2.microsoft.com/en-us/library/ms191307.aspx how to write the international date constants for MS SQL...