Current Population Question
Hi, hoping you can help me with determining the number of youth in our facility on a specific date. I have used a calculation called "current" for many years which gives me the number of youth in the facility in "real time", ie today--by using IsEmpty(Discharge Date). However I need a way to show the number of youth in the building when I enter a date into a "global date field". Each youth has an admit and discharge date. In the past, I have also used a script to generate a census for a specific date by using a script that works something like this: Set field (Admit Date<=Find Date and Discharge Date >= find Date; duplicate Record/Request; Set Field "Discharge Date "=")that "finds" the # of kids when the date is entered, but I would like to be able to open a screen (like an "interface" screen); type in the date and have the #'s populate/show in a portal row. Is this possible?