Project and Portfolio Management Practitioners Forum
cancel

How to see time sheet submission date

Highlighted
Mohit_Agrawal
Outstanding Contributor.

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
Super Contributor.

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
Outstanding Contributor.

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