AnsweredAssumed Answered

How can I calculate the difference between two datetimes in KReporter?

Question asked by ajones ajones on Jun 3, 2014
Latest reply on Jun 15, 2014 by christianknoll christianknoll
Hello,

I was wondering if someone could provide me with some advice on how to calculate the difference between two datetime fields in a report using KReports v3.0.5 & Sugar CE 6.5

I have got a date created field and a date modified field in my manipulate tab and I have added a fixed field called Difference. I have stored date created as 'A' and date modified as 'B'. In the CustomFunction for Difference I have tried a whole host of different functions and subtractions etc and I simply cannot get this to work. The report pulls back date created and date modified but does not calculate the Difference. At present the CustomFunction I have is:

timediff({B},{A})

Am I heading in the wrong direction?

Any assistance is greatly appreciated.

Thanks,

Allan

Outcomes