Date Table Update

1. Overview and Context

This procedure updates the date table in the SQL Database.

2. Triggers

The execution of this procedure is usually triggered by

• Metrics

3. Steps to Be Performed

The Date Table in phpMyAdmin needs to be updated every month with the last month.

• Go to DateTable
• SQL Tab

To add:

INSERT INTO `DateTable`(`Date`) VALUES ("2021-01-01")

To delete:

DELETE FROM `DateTable` WHERE `Date` = "2021-01-01"

4. Additional Information

5. Document Control