Update sql field date from excel file

Transact-SQL
21

so obviously it is not working :grinning_face_with_smiling_eyes: are you sure you are connected to the right sql server backend? it is not pointing to some sandbox?

Is something being rolled back by the system itself?

22

as I said before, when I change the quantity for example it's working.
just not the date.

23

This tells me the column you are updating is not the actual column being used by the ERP system. My guess is that there is another column that is being used - that is probably updated through code when that field is changed in the application.

What other columns exist in the PORDERITEM table?

1 Like
24

this is the right column.
once I update the field in the ERP system, I'm seeing the change in this column in database.

25

That doesn't mean there isn't another column being used. Not much else we can help with - you might have better luck asking Priority ERP on how to get this task done.

1 Like
26

In that case , there is a bug in the ERP system. file a bug with them

27

found the problem.
should have update column REQDATE instead DUEDATE.
I want to thank you both for the effort. really.

1 Like