cancel
Showing results for 
Search instead for 
Did you mean: 

How can I convert excel date integers into DateTime

tsandi
OneStream Employee
OneStream Employee

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?

1 ACCEPTED SOLUTION

tsandi
OneStream Employee
OneStream Employee

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:

tsandi_0-1635242034101.png

Original dateset:

tsandi_1-1635242083284.png

 

View solution in original post

1 REPLY 1

tsandi
OneStream Employee
OneStream Employee

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:

tsandi_0-1635242034101.png

Original dateset:

tsandi_1-1635242083284.png

 

Please sign in! tsandi