- Posts: 89
- Thank you received: 1
Excel Date Formatting
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
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
Please Log in or Create an account to join the conversation.
9 years 11 months ago #8287
by admin
Mike
ETL Architect
Replied by admin on topic Excel Date Formatting
Are you loading data from excel or are you creating excel files?
Mike
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
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
Charlie
Please Log in or Create an account to join the conversation.
9 years 11 months ago #8290
by admin
Mike
ETL Architect
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
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
9 years 11 months ago #8292
by AltPac
Replied by AltPac on topic Excel Date Formatting
Screenshots are attached.
Please Log in or Create an account to join the conversation.
9 years 11 months ago #8305
by admin
Mike
ETL Architect
Replied by admin on topic Excel Date Formatting
This problem was reproduced and fixed in the latest release
Peter
Peter
Mike
ETL Architect
Please Log in or Create an account to join the conversation.