Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Request Completion date

SOLVED
Go to solution
Highlighted
Govardhan07
Regular Collector

Request Completion date

Hi,

 

I need to retrieve data related to requests but condition is its completion or cancelled date is between January 1st 2011 to December 31st 2011.

 

My question is where to find exact completion or cancelled date of the request and which table contains this date.

 

Please help me.

 

Regards,

Govardhan

2 REPLIES
Niraj Prabhu
Frequent Visitor
Solution

Re: Request Completion date

Govardhan,

KCRT_REQUESTS_V should give you all the information you need, you are looking for LAST_UPDATE_DATE, and make sure that you use the STATUS_CODE to sight the status of the request you want to search.

You can use the between on the LAST_UPDATE_DATE column within where clause to restrict the search.

Regards,
Niraj
Niraj P.
Raj Ghimire
Occasional Visitor

Re: Request Completion date

Unless you have custom fields to capture info like Completion date, you can query the LAST_UPDATE_DATE column in KCRT_REQUESTS to get the desired output.

Thanks.

-Raj

//Add this to "OnDomLoad" event