Search results for query: *

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"...

I figured it out, if anyone wants a copy let me know.

Steve you don't happen to some sample code for that???

Thanks I have done that in Crystal.

We have 11.5

How do I do elapsed time in BO using date and time fields.

Call me a sexist pig then. Sorry for the incorrect assumption.

Lance Bass is a winner! He can sing, dance and write Crystal code. Thanks this works really well. Budoyboy

name mrn date result DOE,JOHN 1234576 8/21/2008 1.9 first test DOE,JOHN 1234576 8/22/2008 1.7 DOE,JOHN 1234576 8/23/2008 2.2 DOE,JOHN 1234576 8/24/2008 1.4 DOE,JOHN 1234576 8/25/2008 1.8 DOE,JOHN 1234576 8/26/2008 3...

It is sort of working. It taking the lowest test compared to the highest when it should be first compared to the highest.

I will try it and let you know. Thanks

I just found what they want is if any lab result is greater than the first lab result by 1 than flag it

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...

Sorry it is working great thanks for your help

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.

The patients are all on the same floor, but different beds sometimes. What happens is that they can go from one bed to another on the same day and these patients should be counted only once. You also have patients that can stay in the same bed their whole stay and they should be counted only...

Yes sort of What I am trying to do is if the account number is the same i.e. same patient and the DATE ENTERED UNIT = the DATE LEFT UNIT of the next line then give me a 1. If the account number of the enxt line match and the DEU and the DLL don't match also give me a 1. Sometimes a patient...

if onfirstrecord then 1 else if (previous({ENC_ICU_ADM_VIEW.ACCOUNT_NUMBER}) ={ENC_ICU_ADM_VIEW.ACCOUNT_NUMBER} and previous({ENC_ICU_ADM_VIEW.DATE_ENTERED_LOCATION}) = {ENC_ICU_ADM_VIEW.DATE_LEFT_LOCATION}) then 0 else 1 The above code worked sort of. I am getting a 1 for the first...

if not onfirstrecord then if previous({ENC_ICU_ADM_VIEW.ACCOUNT_NUMBER}) ={ENC_ICU_ADM_VIEW.ACCOUNT_NUMBER} and previous({ENC_ICU_ADM_VIEW.DATE_ENTERED_LOCATION}) = {ENC_ICU_ADM_VIEW.DATE_LEFT_LOCATION} then 0 else 1 I can get a 1 on all the records except the first one so I can get a...