Question
Accenture
IN
Last activity: 29 Mar 2016 6:54 EDT
Converting a double value to date
After parsing an excel, i am getting the date values as double values. Now if i want to convert the double value to date using Java, how can i do this?
Accepted Solution
Pegasystems
IN
You can code something like this in a Java step of an activity or a rule-utility-function. Instead of the hardcoded double that I used, you can pass in the value you read from Excel.
Pegasystems
IN
Please take a look at this - http://stackoverflow.com/questions/19028192/converting-number-representation-of-date-in-excel-to-date-in-java
Note that Apache POI is already part of Pega platform.
Accenture
IN
Hi Rajiv,
Thanks for your help! But I am facing issues with the Java code when I am trying to implement it. I have a property AMDate in which I am parsing the double valued date. But when I am trying to write a java code-public static java.util.Date getJavaDate( double AMDate),it is throwing error. Can you help me with the java code for this?
Accepted Solution
Pegasystems
IN
You can code something like this in a Java step of an activity or a rule-utility-function. Instead of the hardcoded double that I used, you can pass in the value you read from Excel.