Question
Ernst & Young LLP
IN
Last activity: 17 Feb 2021 10:12 EST
How to Convert Double to Date in a Data Transform
Hi All,
I have a requirement where i need to convert a double property value to Date property value in a Data Transform.
The example for double property value is as: 305942400000
Pls guide some solution. Please share the java code along with the function screenshots.
Regards,
Parwej
Accepted Solution
Pegasystems
US
Create a new function as shown below .. eg name : DoubleToDate
Then from your DataTransform call that function :
HCL Singapore PTE LTD
SG
Hi,
"line: 1
The method getjavaDate(Double) is undefined for the type DateUtil
line: 2
olog cannot be resolved
Library—
The Library failed to compile"
Did you face the above kind of error,if so how did you fix.
Thanks in advance
Crochet Technologies
IN
Thank you
Ernst & Young LLP
IN
Hi Sunny,
There is one small doubt.
The sample value i have given above is : 305942400000
Why have you taken only 30594.00 as the input value for the function?
What if the value is like "717292800000". Do we need to take the first five digits only in all the cases?
Regards,
Parwej
Pegasystems Inc.
DE
How do we have to interpret the value in that double property? Is it "milliseconds since the begin of the epoch"? If so, try this:
return String.format( "%tF", java.lang.Math.round( dateDouble ) );
It the date is encoded to the double value in a different way, we first need to know details about that format.