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

How to see time sheet submission date

Highlighted
Mohit_Agrawal
Frequent Visitor

How to see time sheet submission date

Hi All,

 

I need to fetch the time sheet submission date. I see that timesheet transaction history shows that informaiton but what is the table name for that...

 

The date on which time sheet went to "Pending Approval"...

 

Thanks.

2 REPLIES
Scorpex
Member

Re: How to see time sheet submission date

Mohit,

would getting the time sheets from tm_time_sheets where status_code = 2 and looking at the last update date not work?

 

I'm curious about this as well.

 

Thanks!

Mig

Mohit_Agrawal
Frequent Visitor

Re: How to see time sheet submission date

Mig,

 

This is only going to give submission date for the timesheets which are "Pending Approval".

 

How do I get the submission date for timesheets are approved, closed or forzen??

This is what I'm looking for

 

Thanks

//Add this to "OnDomLoad" event