This is caused by a few things, mainly the field properties on the CE form and the type of column this data is stored as on FO side.

For CE, that ship date value on the Order form is a Date only field on the form with User Local behavior:

The different behaviors for that type of CE field, which says User Local behavior will modify the value to the current user’s timezone.

For FO, that table field doesn’t store the time because it is a Date field and not a Datetime field so when it is stored in SalesTable it doesn’t store the time or the time Zone information; when it is integrated to CE via DW it is just that date at midnight (ex: 12/10/2022 00:00:00). Then in CE when you open the form, that field date value will be modified based on the user’s time Zone. So if the user is GMT-6, 12/10/2022 00:00:00 turns into 12/09/2022 18:00:00.