how to modify "date to" of a timesheet

mortoray · **Joined:** Mon Aug 17, 2009 7:35 am **Posts:** 20

After a timesheet has been saved (still in Draft status) there is no option to modify the "date to" in the header of the form. There was an entry in the wrong period on the timesheet which I've now removed, but it still won't let me adjust the end date.

How can I modify the end date?

mortoray · **Joined:** Mon Aug 17, 2009 7:35 am **Posts:** 20

I found no option to change the end date in the interface. I resorted to modifying the database.

Lookup the id in the hr_timesheet_sheet_sheet table:

select * from hr_timesheet_sheet_sheet;

then update the date:

update hr_timesheet_sheet_sheet set date_to='2009-11-30', date_current='2009-11-30' where id=13;