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?

@kaustubhjain What is the output value format which you are getting from RD?

@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.

All seem to point to DifferenceBetweenDays function from BusinessCalendar library.

@kaustubhjain Open Report Definition in Query tab at Date row open settings icon there you can give and try.

@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]