// formName variables.formName = formName; //variables.navroot = navroot; // fieldName if (isDefined('fieldFromName')) { variables.fieldFromName = fieldFromName; } else { variables.fieldFromName = 'From_Date'; } // fieldName if (isDefined('fieldToName')) { variables.fieldToName = fieldToName; } else { variables.fieldToName = 'To_Date'; } variables.days = -1; if(isDefined("session.DateFromToDays")) { if(session.DateFromToDays gt 0) { variables.days = session.DateFromToDays; } } // fieldValue if (isDefined('fieldFromValue')) { variables.fieldFromValue = fieldFromValue; } else { // Changed by me to hold current date if(variables.days gt 0) { variables.fieldFromValue = DateFormat(dateadd('d', -#session.DateFromToDays#, Now()),'mm/dd/yyyy'); } else { variables.fieldFromValue = DateFormat(dateadd('m', -1, Now()),'mm/dd/yyyy'); } } if (isDefined('fieldToValue')) { variables.fieldToValue = fieldToValue; } else { // Changed by me to hold current date variables.fieldToValue = DateFormat(Now(),'mm/dd/yyyy'); } // Other Fields if (isDefined('OtherFields')) { variables.OtherFields = OtherFields; } else { variables.OtherFields = ''; } // Submit Button if (isDefined('ButtonText')) { variables.ButtonText = ButtonText; } else { variables.ButtonText = 'Submit'; } // back if (isDefined('back')) { variables.back = back; } else { variables.back = 'no'; } if (isDefined('action')) { variables.action = action; } else { variables.action = ''; } if (isDefined('title')) { variables.title = title; } else { variables.title = 'no'; } // scriptPath if (isDefined('scriptPath')) { variables.scriptPath = scriptPath; } else { variables.scriptPath = 'popDateTime/'; } select * from #Request.prefix_db_agency#.Locations SELECT pe.Emp_ID AS Employee_ID, pe.Emp_Last AS Last_Name, pe.Emp_First AS First_Name FROM #Request.prefix_db_lookup#.pEmployee pe WHERE pe.Loc_ID = '#session.AgencyId#' AND pe.Status IN (0,1) ORDER BY pe.Emp_Last, pe.Emp_First

Select Date Range

" placeholder="Select Date"> to " placeholder="Select Date">

Date Format: mm/dd/yyyy

Select OASIS Type:

checked /> 6 checked /> 7 checked /> 8 checked /> 9

Select one or more OASIS discharge/transfer types.

Employee Name

Select All Employees | Clear Selection

Leave unselected for all employees. Hold Ctrl/Cmd to select multiple.