Announcement!
This is a notification for product news or an alert. If you have a question, please start a new discussion

Sales Order Import Utility - not recognizing dates correctly

SUGGESTED

Good day.  I've setup a SO Import using the Utility.

I import from excel.  

For some reason the import dates will not accept date format dd/mm/yyyy, even though the server & workstation is set that way.

I had to change the import defaults to dd-mm-yyyy,

I do however now have a frustrating situation.

On the import document, I cannot stipulate dates greater that the 12th of the month or the import fails with the message "does not recognize date format".

Example; if the order date is set to 01-11-2023, the import works.  if set to 13-11-2023 it does not work.

Please help