Question
Tetco
SA
Last activity: 29 Sep 2017 0:27 EDT
Date Difference in days hours minutes format.
Hi,
I do have a requirement where we have to show the DateTime difference in days/hours/minutes formats.
Current the the Pega Fuunctions used are returning either in Days or Hours or Minutes or Seconds alone, do we have any OOTB Function available in Pega which provides the difference in combination.
For Example whenever i get the difference i should get the output as 2 Days 3 hours 8 minutes format.
Thanks in advance.
Accepted Solution
Tetco
SA
Currently to achieve this i am getting the Difference in seconds and then doing the calculation in Data Transform to calculate the day(s), hours and minutes and then based on the outputs i am appending the day hour and minute to string and getting the output as A days B hours C minutes. I want to avoid calculating from our side, there should be some way in Pega i am sure, please suggest.
Pegasystems Inc.
IN
Hi Shoaibahmed,
Can try the one of the below functions and see if it helps you in achieving your requirement:
1. @differenceBetweenDays(Param.NewDate, Param.OldDate, false, Default)
2. @differenceBetweenDates(Param.NewDate, Param.OldDate, false, Default)
3. DateTimeDifference(dateproperty1, dateproperty2, "s") = 1504.0
NOTE : This function is for Datetime property.
Regards,
Vikash
Tetco
SA
Hi Vikas,
Thank you for your response.
@differenceBetweenDays(Param.NewDate, Param.OldDate, false, Default) it returns me the only the number of days i have already gone through all the available functions.
DateTimeDifference(dateproperty1, dateproperty2, "s") = 1504.0 returns the value in string, as i mentioned in my post i am looking for such function which returns me in below format
2 days 2 hours 3 minutes, I need output to be combination of days/hours/minutes as i don't find any function for such requirement i am getting the seconds value and i am forming a string to get the output in above format.
Tetco
SA
We don't find any OOTB function to resolve the issue so we are find the difference in seconds and then using Data Transform i am converting seconds in days hours and minutes and then i am forming into a string format to get the format in days hour and minutes.