Change Of DataType

RS8

Hi,

In Sales Header there is a field named "Time Of Removal" with DataType as "Time". I am supposed to change it to "DateTime" Datatype. Will ther be any program / functional error on modifying, or wil it effect in other modules. I have changed in al respective tables related to it.
can anyone clarify the same.

kapamarou

Why didn't you just create a new field? That's would be the best solution.

RS8

From Outside Database I am inserting Data into SalesHeader, through SQL, where i have only datetime datatye in SQL, while opening navision Table sales header i get an error in that Time of Removal field. It inserts both date and time, but in navision i need only time data, to be stored,, any solution for this..

kapamarou

Did you try this?
viewtopic.php?f=23&t=33737

RS8

wat should i insert into SQL table, the value for "Time of Removal" field in Navision, so that i can get only time in Nav, can you tell me the exact value.

kapamarou

Let's assume you need to insert time as 15:14:12.

Then in the SQL DateTime field you will insert 1/1/1754 15:14:12.

Try it to see if it works...

DenSter

It's easy to figure out. Take a look at the field values in SQL Server to figure out what to use for the date portion of the field.