Skip to Content (Press Enter)
UserImage.jpg
Quinn Eschenbach
364Views
3Comments
Importing Dates from Excel
Discussion
How-to

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

0
0
18 Jul 2018
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

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.

0
0
18 Jul 2018
Copy Link
UserImage.jpg
Quinn Eschenbach

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


0
0
19 Jul 2018
Copy Link
2020-03-17 09-53-46
Marc Bartel

AddDays(#1900-01-01#, TextToInteger(Cell_Read_ExpiryDate.CellValue)-2) 

0
0
17 Sep 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.