Re: excel date

D Xls_StartDate   S               D   inz(d'1900-01-01')
D MyDate         S               D   datfmt(*DMY)

MyDate  =  Xls_StartDate + %days(%int(cellValue)-2);


----- Original Message ----- 
From: "Basilio Merlino" <bmerlino@xxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, July 05, 2005 12:07 PM
Subject: excel date




   Dear all ,



   I try to use the jakarta poi class to read an excel spreadsheet , but i
have encoured in this problem , on the excel sheet i have a cell that is
   fo=matted like date , when i read the value from the rpg program whats i
   see =s not the date but the number corresponding .



   So have you some idea how can read the formatted value?



   Thanks in advance



   Basilio