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.
Go to Solution.
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.