x Want to participate? Join the group to interact
  • State Suggested Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 1 answer
  • Subscribers 21 subscribers
  • Views 219 views
  • Users 0 members are here
Browse Forums
Announcements
663
topics
57
replies
General Discussion
2k
topics
5k
replies
Intelligence Reporting
349
topics
837
replies
Announcement!
This is a notification for product news or an alert. If you have a question, please start a new discussion
JacoPrefsol

Sales Order Import Utility - not recognizing dates correctly

SUGGESTED
Posted By

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

  • 0
    SUGGESTED

    Hi Jaco

    Please confirm the following so I can have a proper understanding of your query. 

    1. Sage Evolution version?

    2. You stated the following above: 'will not accept date format dd/mm/yyyy'

    Please elaborate a bit on what you mean. Is there some kind of error message when importing the file or what exactly is happening?

    If there is an error message, please paste it into this chat.

    3. On the Data Import Defaults, is the File Settings option set to MS Excel or Delimited Format?

    4. Please test what happens if you change this setting and then import. E.g., it's currently on MS Excel, therefore change it to Delimited Format, save your import file as a CSV file, and close it. Then import and check what happens.

    5. What is the current Short Date format used on the local PC's Control Panel | Region | Regional Settings | Short Date Format?

    6. Have you ensured the Short Date Format on the import file is exactly the same as in 5. above? 

    Kind Regards

    Bennie 

  • 0 in reply to Bennie Pienaar

    The Evo version is 10.1.3.009

  • 0 in reply to JacoPrefsol

    Thanks, Jaco

    I'll await the rest of the answers to the above questions and will then be able to respond. 

*Community Hub is the new name for Sage City