Page Comparison

...

1. Decide dates and direction of the change.

2. Take a backup of the database before running script.

3. Open script wbData_ChangeWEDate.sql in Notepadd++ (or any text editor) and edit parameters. Save and then open this script in the CORRECT SQL database.
   This is a sample of the parameters that must be configured:
   

   Image RemovedImage Added

4. Execute script.

5. Then populate the statement below with the new Week Ending day, and execute it. Or you can update it using Scaffold on Web Workbench, on the Control table.
   UPDATE dbo.control SET WeekEndingDate WeekEndingDay = 'Friday'

6. Validate Timesheets:

   1. Open existing ones and new ones.

   2. Create new timesheets. Specifically validate the current, past and next week.

7. Once validation is done, inform users they can log back in.