Convert Excel date number value to proper date

One Star

Convert Excel date number value to proper date

I have a csv file which was exported from an excel file. 1 of the columns is a date value but displayed in the underlying number excel uses to store dates i.e its not formatted as a date its a number that represents the time elapsed since Jan 1 1900 ( I'm open to correction on it)
I was wondering whats the best way to convert it into a date I can store in a date field of a schema definition?
I'm not sure how to phrase the query so apologies if its a common query but searching the forum I came across this post from 2008 and I was wondering if there was a more mainstream method the community uses since then? 
Old forum post
One Star

Re: Convert Excel date number value to proper date

It seems I can't post links using the WSYIWYG editor 
Also this was incorrectly tagged as a db2 database issue. its related to excel date's underlying number value and how to convert that to a date value acceptable to other systems and format it into a user friendly representation 
One Star

Re: Convert Excel date number value to proper date

Convert Excel's number into the number of milliseconds past Jan 1, 1970 00:00:00 GMT and then use the java Date constructor.
Highlighted
One Star

Re: Convert Excel date number value to proper date

Convert Excel's number into the number of milliseconds past Jan 1, 1970 00:00:00 GMT and then use the java Date constructor.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download