Question
Cognizant
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
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.
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.
Cognizant
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.