Data Shuttle converting mmm d, yyyy date format to numerical value

Hello Everyone,

I have a Data Shuttle workflow that has been run virtually every business day for over a year. When running today, four columns of dates converted to numerical values.

No formatting of the source sheet has changed (Excel file with a Custom category of mmm d,yyyy

Cell history confirms date format used to be present

The existing columns are configured to Auto in Data Shuttle, but I created two new columns to test columns types of Text and Number, but they do the same thing.

Changing the format of the cells in the Excel resolves the issue, but I cannot find the clue to how it worked prior to today.

Anyone experiencing this issue?

Tags:

Answers