Last modification and submitted time of a time sheet in project server 2010 RRS feed

  • Question

  • Hi,

    I am trying to find the submitted time of the time sheet by employees. The Modified_Date column in MSP_TIMESHEETLINE_USERVIEW has the time the employee submitted his timesheet for the first time it's locking in when the initial submit is done. If the employee recalled his time sheet, modified it and resubmitted the timesheet it is not showing the new submit time. Is there any other table which has the correct submit time of the timesheet in the database??

    Sunday, June 29, 2014 9:56 PM

All replies

  • Hi,

    It seems strange to me that the modified date is not updated in case the timesheet is resubmitted. I cannot test it right now but I guess you tested twice.

    In this case, you could for example use the event handler to catch the date (in a custom field for example) on the timesheet submission event.

    Hope this helps,

    Guillaume Rouyre, MBA, MCP, MCTS |

    Monday, June 30, 2014 12:49 PM