datetime format error Nav2009 VS. SQLEXPRESS

AleSlammer

Hi all

I have a table where a .Net program writes some data in it. The problem is that I can't open the table, after data has been inserted because of an error message saying: "The eSalestable contains datefield data that has uses invalid data for the time component of DATETIME value:
field: Create Date
value: 2010-01-26 12:23:22.000"

The funny thing is, that when I open the SQL Server, the date has the value 2010-01-26 12:23:22 so no ".000" behind it. It looks exactly the same when opening the G/L ledger entry and looking at the Document date, which is also a datetime data type.
Do any of you know what the problem is, and how to fix it ? :-k

kine

May be that problem is, that the field is DATE field in NAV, not DateTime, thus time must be zero!

AleSlammer

yes, you were right. I thought I had changed it to datetime, but it was in the development system I had done it, not in the testsystem. Thanks for pointing that out.
#-o