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.
:) :)
Quote from: gosoccer on 12 Jul 2015 06:42:56 PM
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.
:) :)
_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.
Yeap! Thanks so much Lynn. :)