Default date is only for the End_Date.
If I'm running the report for the Date Range 11/1/16 to 11/30/16, I want to capture all patients that their START_DATE and END_DATE fall within that range.
I have a table that captures patients that belong in a registry with a START_DATE field and an END_DATE field. I've added a Date range parameter {?Date Range} so I can run this report for whatever date range requested.
I'm struggling to write a select statement that will include the patients...
I have a report where I am passing a shared variable that lives in the Group Header 1 in the subreport and trying to display in the Group Footer 1 of the Main Report. Not every subreport returns the value I'm passing so I get the value on the main report the first time it shows up for a...
We have to do this with a copy of the original ADT table.
ADT_TABLE(FIRST_ENCOUNTER) link to copy of ADT_TABLE(FUTURE_ENCOUNTERS), link by the PAT_ID (a unique id that is in both tables that is specific to the patient but will not limit by encounter)
CoSpringsGuy,
{@Elapsed Time By Days Variable} = datediff("d",{@tot display 1st Discharge Time},{@tot1 display 2nd Admit Time})
It's calculated by doing a datediff on two times calculated using variables.
IanWaterman,
That did the trick. It is working perfectly. Thank you.
I have a field in the Group Footer called Elapsed Time By Days. This field is calculated by a variable and is a number. I'm wanting to create a parameter that allows the user to select "0 ot 7 Days", "8 to 30 Days", and "31 to 90 Days" and then they would only see records with those values...
Group 1 Header Department Admit Time
Detail line 1 Dept 1 8:00
Detail line 2 Dept 2 9:00
Detail line 3 Dept 3 10:00
Group 1 Footer Dept 1 (this is the value I want to see but if a do a Max or Min summary I keep getting either Dept 2 or Dept 3 because their...
Are those 2 fields Dates or DateTime? They are Datetime fields.
Are new records created on re-admittance? Yes, they each have a new {Patient.CSN} for each admit.
Neither of those fields seems to have a readmit date or time.
There is no readmit field in our tables.
BTW, what have you tried...
I am trying to find a way to display a readmit date for patients that is less than 7 days from admit date.
The fields I’m working with are {Discharge.Effective Time} and {Admit.Effective Time} . I also a group on {Patient.MRN}. Every thing I try keeps bringing up the same dates multiple times.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.