This is not my solution, I got it from another forum
Ok, try this. I am going to assume that you have access to Universe designer and that the 4 columns of data are datatype "date". In designer, create "Admit Date" by concatenating admit date and admit time. Do the same for "Discharge Date"...
Hello,
I get lab records listed below. What I want to do in Crystal is compare the first record to the last i.e.result 1.9 to 3 and to see if the results are greater than 1(which in this case is true). Does anyome know how to look at records for one patient can compare the first and the last...
I see what you are saying except patients get moved around i.e. new bed numbers and you get a new date entered. I would be overcounting the number of admits to the unit.
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.