Importing Dates from Excel

Importing Dates from Excel

  

Hi Guys 

Im trying to import an excelfile to my program but instead of dates i only get an Integer (e.g 04.06.2018 is imported as 43261)

Is there any way to reformat it to a date?

thanks

Hi Quinn,

I don't quite understand. If we are talking about the built-int Statement Excel To Record List, it has as Property the Record Definition. If in the Structure you specify there there's a Date Attribute, a Date is imported. It can never be an Integer.

Hi Kilian,

i used a script to be able to access specific Cells. I found the Solution (its Adding the number in Days to 01.01.1900).