Skip to main content
T
tsandi
October 26, 2021
Solved

How can I convert excel date integers into DateTime

  • October 26, 2021
  • 1 reply
  • 0 views

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?

    Best answer by tsandi

    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

     

    1 reply

    T
    tsandiAuthorAnswer
    October 26, 2021

    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

     

    Terms & ConditionsAccessibility statement