-
I am using JetReports to generate most of my reports. For some of them, I am also using VBA and ADO to get the result directly from SQL Server 2005 database and import it into Excel . The problem I have been having with the latter is that if I need to get the value of a field that has DateFormula (1W...
-
Use CAST and CONVERT to format the datatime field for Navision EXAMPLE: CAST(''1754-01-01 ''+CONVERT(CHAR(8), [StartTime], 108) AS DATETIME) Where StartTime is the SQL datetime field. This will set the date to 01/01/1754 and display time as hh:mm:ss
-
Imcurrently working on a project to integrate a mobile solution to Navision. We have decided on a stagin table route directly into the underlying SQL database. I an currently having an issue with the Nav Time field, which is seen as datetime on the sql server table. This issue i have is using sql insert...
-
Thanks for the prompt response. The issue I was having is not with how to enter the datetime or even casting it. I think you may have answered the question. I am more concerned with why the date is 1754-01-01, and where this comes from.
-
Again thanks for your quick response but the earliest datetime in sql server is 1/1/1753, which is why I was a bit confused about 1754 being the date.