How to see time sheet submission date

[Mohit_Agrawal]

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.

[Scorpex]

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]

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