How can I convert excel date integers into DateTime

[tsandi]

I have a csv import coming from excel. One of the columns is of type date but when it gets saved into CSV the date is replaced by integers in the format excel uses to store dates. How can I convert those integers back into dates?

[tsandi · Accepted solution]

You can use a complex expression in the data source column itself to convert the date:

Dim excelDate As Integer = args.Value
Return DateTime.FromOADate(excelDate)

This will return the correct date format in stage:

Original dateset: