Question
Infosys
IN
Last activity: 4 Mar 2020 23:30 EST
Converting Decimal to Time value in hours and minutes
Hi I have requirement like i have parsed an excel and from excel i have a property named collection time which is having a value as 0.739583333333333 i need to conver it to time value the actual value for this decimal is 17:35 how this can be achieved in Pega i mean converting decimal to time format
kindly help on this
Pegasystems Inc.
IN
Pegasystems Inc.
US
You can write a java step and convert the property to DateTime equivalent and store it.
ClipboardPage clipboardPage = tools.getStepPage();
ClipboardProperty prop = clipboardPage.getString(".prop")
long timeInMilliSeconds = (long) Math.floor(.prop* 60 * 1000);
Date date = new Date(timeInMilliSeconds);
SimpleDateFormat sdf = new SimpleDateFormat("HH:mm:ss");
sdf.setTimeZone(TimeZone.getTimeZone("GMT"));
System.out.println(sdf.format(date));
Please try this and let me know if you face any issues.
Infosys
IN
Hi Rachit ,
i am getting an error while trying to implement the same attaching the screen also
kindly help
Pegasystems Inc.
IN
Remove the dot before prop and check.
Infosys
IN
its not working and i am getting more sysntax error can you please give me the correct code.
This record has 5 error(s) in 4 place(s) .
—
Java at step: 2 line: 2
Type mismatch: cannot convert from String to ClipboardProperty
—
Java at step: 2 line: 3
The operator * is undefined for the argument type(s) ClipboardProperty, int
—
Java at step: 2 line: 5
SimpleDateFormat cannot be resolved to a type
SimpleDateFormat cannot be resolved to a type
—
Java at step: 2 line: 6
TimeZone cannot be resolved
—
Compile failed.
Hello Praveen
You can convert a decimal value to date value using the "toLocal" and "toGMT" functions.
@(Pega-RULES:DateTime).toGMT(0.847222222219, "America/New_York")
-Rakshith.