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

Time sheet date of approval - How to identify?

Highlighted
Simon Robichaud
Acclaimed Contributor

Time sheet date of approval - How to identify?

Hi,

We need to find the timesheets that where frozen or closed since a specific date.

How can we do that?

Thanks
2 REPLIES
Niraj Prabhu
Frequent Visitor

Re: Time sheet date of approval - How to identify?

Simon,

You can query database table TM_TIME_SHEETS to see the timesheet statud code for APPROVED and look for Last Update Date.

Regards,
Niraj
Niraj P.
Simon Robichaud
Acclaimed Contributor

Re: Time sheet date of approval - How to identify?

I checked and found out that when the status is updated, the column last_date_modified is not updated.
//Add this to "OnDomLoad" event