Managed timesheet period

[Ben N.]

I've inserted a managed time period starting from 1-Oct-2005 till 31-12-2005.
I want to change this to a period of one week (ie. 1-oct-2005 - 7-oct-2005)

how can i achieve this?

 

[Gaurav Wason]

You have to change it in database. You cannot change it though PWA.

Let me know if you have access to Database.

 

[Ben N.]

I assume I can edit this field through Enterprise Manager -> Local Database
->
in MSP_WEB_TIME_PERIODS table?

Is this the only table i need to alter?

Thanks Guarav,

 

[Gaurav Wason]

Yes,

Thats what I did to clear the managed time sheet. This is the query I wrote
might be helpful to you.

DELETE FROM dbo.MSP_WEB_TIME_PERIODS
WHERE (WPRD_ID > 2)


UPDATE MSP_WEB_TIME_PERIODS
SET WPRD_Finish_Date = '12/31/1999 11:59:59 PM'
WHERE WPRD_ID = 1

UPDATE MSP_WEB_TIME_PERIODS
SET WPRD_Start_Date = '1/1/2000'
WHERE WPRD_ID = 2

I just tried to bring the default values back. Please test this query before
running it on your production environment.

Thanks and Let me know