The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
tsandi
OneStream Employee
OneStream EmployeeHow can I convert excel date integers into DateTime
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?
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:
1 Reply
tsandiYou 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: