Page Comparison

...

Once the script is executed the WeekEnding DAY must will also be changed updated on Controls table, either via Scaffold or with a SQL statement included in the steps below.the Control table with the @TargetDay

The script must have 4 parameters set before is executed:

...

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:
   

   

4. Execute script.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 WeekEndingDay = 'Friday'

5. Validate Timesheets:

   1. Open existing ones and new ones.

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

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