Project Controller Current Period SQL Script: select substring(control_data,1,6) from pjcontrl where control_code = 'CURRENT-PERIOD'