Using closing dates to prevent records for future dates

Closing dates are an important feature for data integrity and can be used to prevent records from being entered before and/or after certain dates.

This is useful for two purposes:

1. To prevent users from adding, editing or deleting records after the data has been reported on.
2. To prevent users from mistakenly entering records for a date that is in the future.

The best way to prevent data entry for future dates is to apply a rolling upper closing date of 1.