Question
LTIMindtree
IN
Last activity: 7 Jul 2023 13:05 EDT
How to change the format of date column from GMT to DD:HH:MM fetched from a Report Definition
Hi All,
I am calling a Report Definition where one column is the difference of Two dates which are in GMT.
Now i wanted to display that property on UI but in DD:HH:MM(Days:Minutes:Hours) format.
How can i achieve that?
Accepted Solution
Updated: 7 Jul 2023 13:05 EDT
Pegasystems Inc.
GB
@kaustubhjain if you do a search on the forum for the terms 'days difference count' there are many suggestions in the 'Related content' suggestion box on the right.
https://support.pega.com/question/how-calculate-difference-between-two-dates-using-function
https://support.pega.com/question/date-difference-calculation
https://support.pega.com/question/how-calculate-difference-between-two-dates
https://support.pega.com/question/expression-calculating-no-days-between-two-dates-pega-v84
https://support.pega.com/question/how-find-number-days
https://support.pega.com/question/how-calculate-difference-between-two-dates-business-calendar
https://support.pega.com/question/find-days-between-two-dates-selected-calendar
All seem to point to DifferenceBetweenDays function from BusinessCalendar library.
JPMC
IN
@kaustubhjain What is the output value format which you are getting from RD?
LTIMindtree
IN
@BhanuPrakash_G So we are using one function to calculate time difference in minutes using below function.
The difference in minutes between [Earlier DateTime Value] and [Later DateTime Value]
Accepted Solution
Updated: 7 Jul 2023 13:05 EDT
Pegasystems Inc.
GB
@kaustubhjain if you do a search on the forum for the terms 'days difference count' there are many suggestions in the 'Related content' suggestion box on the right.
https://support.pega.com/question/how-calculate-difference-between-two-dates-using-function
https://support.pega.com/question/date-difference-calculation
https://support.pega.com/question/how-calculate-difference-between-two-dates
https://support.pega.com/question/expression-calculating-no-days-between-two-dates-pega-v84
https://support.pega.com/question/how-find-number-days
https://support.pega.com/question/how-calculate-difference-between-two-dates-business-calendar
https://support.pega.com/question/find-days-between-two-dates-selected-calendar
All seem to point to DifferenceBetweenDays function from BusinessCalendar library.
Updated: 21 Feb 2023 7:26 EST
INTELLATIV india pvt ltd
IN
@kaustubhjainOpen Report Definition in Query tab at Date row open settings icon there you can give and try.