Topic: Grouping dates within range Posted: 25 Apr 2012 at 5:23am
Here is the issue that I am facing..
The report is designed with two date parameters to capture what we call "patients served". That is less technically anyone's ass that touched a bed during the input date range. The record selection criteria is as below:
{EPISODE_HISTORY.PREADMIT_ADMISSION_DATE} <= {?End} and
(isnull({EPISODE_HISTORY.DATE_OF_DISCHARGE}) or
{EPISODE_HISTORY.DATE_OF_DISCHARGE} >= {?Start})
This does works for capturing anyone during the date range, but it ends up having to be run for each month of a year to get a monthly count. Can anyone help with a way to create a range of the dates that could then be grouped by month. So I could run it for a year and then get a monthly count of "patients served" There may be the need for records to be counted in multiple months.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum