datetime format error Nav2009 VS. SQLEXPRESS

AleSlammerAleSlammer Member Posts: 25
edited 2010-01-27 in NAV Three Tier
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

Comments

  • kinekine Member Posts: 12,562
    May be that problem is, that the field is DATE field in NAV, not DateTime, thus time must be zero!
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • AleSlammerAleSlammer Member Posts: 25
    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
Sign In or Register to comment.