Basic Entry Exit Report Prompt

[jeript]

[DataRemedies]

An update to the Entry Exit Entry Date Prompt above: To bring it in line with the formula Prompt Report End in the code section, the Prompt should read 'Report End Date (Plus One Day):' and should read 'Less Than' rather than 'Less Than or Equal To' . The reason, all dates contain a time stamp (usually defaults to 12:00:00am), in the above example the last day of the report would be excluded.

[jeript]

Thanks. We haven’t been consistent in applying report start/end or “less than”, which definitely shows.

ETA: Screen shot updated.

[jeript]

This query relies on HUD reporting logic, where entries are retrieved for any clients who exited the project after the report start date, who have not exited at all, and clients who entered after the report start date. The first 2 filters prevent deleted or inactivated client or entry data from being retrieved.

[jeript]

By default, this query will result in the Report End Date prompt appearing before the Report Start Date prompt. To adjust, go to the Query Panel and click the Show Query Properties icon. Adjust the order in the Prompt Order section.