We need to calculate the difference between two dates to get the output as ‘10 days 12 hours 25 minutes 2 seconds’ using the Function Alias rule.
We need to calculate the difference between two dates (.pxCreateDateTime and .pyResolvedTimestamp) to get the output as ‘10 days 12 hours 25 minutes 2 seconds’ using the Function Alias rule.
differenceBetweenDays function alias will give the only difference between two dates in days.
Does any other function alias available to get the output as 10 days 12 hours 25 minutes 2 seconds’ as a difference between two dates (.pxCreateDateTime and .pyResolvedTimestamp).
***Updated by moderator: Lochan to branch reply and create new post***
Pegasystems Inc.
US
Hi Nilesh,
There is no direct utility that does what you need. You'll have to use the below function to get the difference in days, hours, minutes and seconds separately.
@DateTimeDifference("20090109T160000.000 GMT","20090119T162504.370 GMT","m")
Please keep in mind it gives the total mins difference between two datetimes. You'll have to manually process the result by dividing by appropriate number(based on minutes seconds or hours).
Pegasystems Inc.
US
Hi Nilesh,
You can use the below approach.
1) Calculate the seconds using DateTimeDifference function.
2) Write the Java Step to calculate Days, Hours, Minutes, seconds using java TimeUtil class.
`
Regards,
Rachit
Virtusa Corporation
US
You are asking about function alias, so you must be needing this functionality in Report Defination.
In RD you don't need to do anything we have Setting Icon on each column. There you can select column format as DateTime and click on Magnifing Icon and select the format you need. Days,Hours,Min