Open and Close Periods – SQL

The Open and Close Periods process closes the earliest open time period and opens the first closed time period after the latest open time period. This process may be used for a non-administrator to open and close time periods without having access to the administrative side. The process is executed through the job Execute Process. For example, our oldest time period is January 6, and our most recent is May 1, it would close out January 6, and open a time period for the week after May 1.