Convert Excel Date value to Pega DateTime format
Create a function with String as input and DateTime as return type. Place the below code in the function.
if(strDate == null || strDate.equals("")){
return null;
}else{
Date javaDate= DateUtil.getJavaDate(Double.parseDouble(strDate));
SimpleDateFormat sd = new SimpleDateFormat("yyyyMMdd'T'HHmmss.SSS");
return sd.format(javaDate)+" GMT";
}
***Updated by moderator: Lochan to unmark post as question***
Posted: 7 years ago
Pegasystems Inc.
IN
Hi Srihari,
Thank you for sharing how to steps on converting Excel date value to Pega dateTime format. It will help the users looking for information on the same.
Regards-