Excel Date Formatting

More
9 years 11 months ago #8285 by AltPac
Excel Date Formatting was created by AltPac
I’ve been running on 5.7.2.2 for some time now and tried to upgrade to 5.7.5.2 last Friday. All of my excel transformations over the weekend had issues with dates coming over as 01/00/1900. See attached screenshot.

I noticed that your comments on version updates regarding 5.7.5.2 stated:

“Addressed problems with formatting dates”

Could it be that fixing one issue may have caused my issue within Excel? Anyhow I reverted back to 5.7.2.2 and recreated all of the files properly.

Charlie
Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #8287 by admin
Replied by admin on topic Excel Date Formatting
Are you loading data from excel or are you creating excel files?

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #8289 by AltPac
Replied by AltPac on topic Excel Date Formatting
I'm starting from Tab delimited text files and creating excel files.

Charlie

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #8290 by admin
Replied by admin on topic Excel Date Formatting
ok in this case can you post a screenshot so we can see source data and date format you are using

Mike

Mike
ETL Architect

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #8292 by AltPac
Replied by AltPac on topic Excel Date Formatting
Screenshots are attached.
Attachments:

Please Log in or Create an account to join the conversation.

More
9 years 11 months ago #8305 by admin
Replied by admin on topic Excel Date Formatting
This problem was reproduced and fixed in the latest release

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.