Page 1 of 1

Property group - Create a calculated field (date diff)

PostPosted:Tue Nov 27, 2012 5:43 pm
by mindbizz
Hello everyone.
I'm a newbie to OpenKM and I'm trying to creating a calculated filed that returns a difference in days of two date fields in a same property group.

Let's say that I have a field named firstdate and another field named lastadate. Now I need to know how many days are between them.
As far as I know in SQL I can do this: SELECT DATEDIFF(lastdate,firstdate)

I'm not a expert programer and I need some help to do this in OpenKM.

Thank you

Re: Property group - Create a calculated field (date diff)

PostPosted:Thu Nov 29, 2012 10:46 pm
by jllort
Actually this kind of feature can not be solved in a easy way. Is needed some change in source code to get it. Basically I think the most easies way for doing it is extending automatic task -> event change metadata. And each time metadadata is updated then calculate it.