How to find the date of the status change in CRM Service Request

[former_member205429]

Hi ALl,

I have a requirement to

1. Get the date when the status of the CRM Service Request is changed from Open to Completed..

I have used CRM_ORDER_READ,CRM_ORDER_GETSTATUS

could not find any clue !!

Can any one pls let me know how do i resolve this issue..

Kindly help asap !!

its a very urgent issue !!

[praveen_kumar194 · Accepted solution]

use the table CRM_JCDS.

[former_member205429 · Accepted solution]

Thanks a lot praveen

Very gr8 help !!!