Date calculations

[ranne_78]

Hello,
I am trying to create a report to show the cases which are there in different process stages for more than 20 days. The issue is with calculating the time duration of each case spent in each process stage there were several actions performed before moving the case from one process stage to other. The timestamp is the only source to calculate the duration in each stage. The logic looks simple like current time stamp minus previous timestamp but how to implement it in 8.2 using Sql Server database. Give me an idea how we can do this with some examples.

Ratnam.

[snadgir30]

Hi ,
I am not sure if i have understood your scenario completely,but i think you can try this out.
  1.Create Calculations that will give min time stamp & max time stamp for particular Process Stage.
  2.Difference betwen these 2 should give you time spent in that Process Stage.
  3. Use the difference calculation created in step 3 as summary filter.

Let me know if it was helpful.

[ranne_78]

Hi Snadgir30,

Thanks for the Reply.

Ratnam