Framework Manager and Calculating Idle Time of a Case Update (10.2.1)

[gosoccer]

Friends,
I have a requirement to calculate an idle time by using certain columns of my Case table.

Case Table:
Case Create Date      Case Status        Case Update Date
07/01/2015                                OPEN                        07/01/2015

Case Create Date      Case Status        Case Update Date
07/01/2015                                UPDATE                    07/15/2015

So, in the above scenario, the Case sat on an Idle State for 15 days.

Now, the question is what calculation would be best to use in the Framework Model's Subject Query to calculate this for every Case. The date field format is mm/dd/yyyy with no timestamp or I can change it with the timestamp.

If you could help, I'll greatly appreciate it.
:) :)

[Lynn]

Friends,
I have a requirement to calculate an idle time by using certain columns of my Case table.

Case Table:
Case Create Date      Case Status        Case Update Date
07/01/2015                                OPEN                        07/01/2015

Case Create Date      Case Status        Case Update Date
07/01/2015                                UPDATE                    07/15/2015

So, in the above scenario, the Case sat on an Idle State for 15 days.

Now, the question is what calculation would be best to use in the Framework Model's Subject Query to calculate this for every Case. The date field format is mm/dd/yyyy with no timestamp or I can change it with the timestamp.

If you could help, I'll greatly appreciate it.
:) :)

Code Select Expand


_days_between ( [Case Update Date], [Case Create Date] )


Is that what you are asking? I think it would give you 14 days for your example rather than 15.

[gosoccer]

Yeap! Thanks so much Lynn. :)