Skip to content
English
  • There are no suggestions because the search field is empty.

FastReactPlan_-_Incorrect_date_format_when_importing_ORDUPDAT_file

Article Public Number: KA-01139

 

Coats Digital Knowledge Article

Product: FastReactPlan

Purpose & Scope:

How to check what date format setting in FRP, and how to correct the date format in the file to suit the setup in system.

 

Solution:

Correct the date format in the ORDUPDAT.TXT/CSV file to match the setting in FRP.

 

Instructions:

Step 1: ORDUPDAT.TXT/CSV that import with date format as DD/MM/YYYY and lead to fatal error that telling us "...wrong length for selected format [yyyymmdd]... as below

Step 2 : In order to avoid this happen, Go to Setup-->Configure-->General-->Import data, we can see the date format setting is yyyymmdd

 

Step 3: Adjust the date format in the ORDUPDAT.TXT/CSV as below, then import again will work.

 

Outcome:

Correct the date format in the ORDUPDAT.TXT/CSV to match the setting in FRP, then import again will work fine.