Question
Cognizant Technology
Cognizant Technology
IN
Cognizant Technology
Posted: Nov 29, 2019
Last activity: Dec 13, 2019
Last activity: 13 Dec 2019 0:46 EST
Closed
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
Posted: 5 years ago
Pegasystems Inc.
Pegasystems Inc.
IN
Hi SandhyaRani,
Thanks for posting the query. PFB link which helps to convert the excel date to Pega date-time format.
https://collaborate.pega.com/discussion/convert-excel-date-value-pega-datetime-format