Product: ImportOmatic

Description: This solution describes causes and troubleshooting steps for date formatting issues

Environment: All

Versions: All

Answer:

There are multiple causes for incorrect date formatting. 

Try the following steps to troubleshoot:

1. Select the "Test Code" button inside of the IOM Profile at the bottom of the open profile view. Select the "Load from File" button at the bottom left of the Code Tester view, browse for the data file in question and select. Next, select the button with the "play" symbol on it located to the right of the "Load from File" button. This will allow you to see the incoming data and the computed data. Does the date appear in the correct format within this view? 

2. Select to Import the data file via the "Import" button within IOM. Select the "review incoming data" check box on the Import screen to see the incoming line of data and check the incoming date field

Try the following steps to resolve: 

Try saving the data file as a .csv file and attempt to view the date field using the above listed steps again. Does this resolve this issue? 

Try formatting the date column within the data file using the right click menu "Format Cells" option within Excel. Attempt to view the date field using the above listed steps again. Does this resolve this issue? 

If the date is appearing as a string of numbers, try creating and using the following dictionary on the date column within the IOM profile: 

How to Format a Data String of Numeric Values to a Date Format - Allows conversion of a string of numeric values to dd/mm/yyyy format.

                Replacement Value: $1/$2/$3

                Value to Match on: (\d+(?=\d{6}))(\d{2}(?=\d{4}))(\d{4}$)