Question

2
Replies
30
Views
SANDHYARANI Member since 2011 4 posts
Virtusa
Posted: 9 months ago
Last activity: 9 months 1 week ago

getJavaDate is not converting to correct date that is given in excel in 8.3

We are using below java function which is working fine in 7.2.2, After upgrade to 8.3 it is not formatting to correct date.

java.util.Date excelStartDate= org.apache.poi.hssf.usermodel.HSSFDateUtil.getJavaDate(LeaseStartDate);
java.util.Date excelEndDate= org.apache.poi.hssf.usermodel.HSSFDateUtil.getJavaDate(LeaseEndDate);

Date we have given in Excel : 28-11-2019

Date that is formatting: 18991231T000000.000 GMT

Low-Code App Development Upgrades
Share this page LinkedIn