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).