Discussion

1
Replies
1709
Views
SrihariS Member since 2015 2 posts
Incessant Technoloies
Posted: August 22, 2017
Last activity: January 23, 2018

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***

Low-Code App Development Developer Knowledge Share
Share this page LinkedIn