Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to get number of days between two events, to know which patients did a same event in less seven days.
The orginal data is like as follow:
PatientID | Patient | Date Event | Hour Event | EventID | Number of days between surgeries |
0122 | GABRIEL | 01/12/2013 | 22:35:00 | 0055|0004|00172627|00000004 | |
0122 | GABRIEL | 03/12/2013 | 11:15:00 | 0055|0004|00172525|00000034 | |
5444 | FABIOLA | 07/12/2013 | 07:43:00 | 0055|0004|00172781|00000020 | |
6231 | TIAGO | 03/12/2013 | 17:34:00 | 0055|0004|00172633|00000021 | |
1010 | DEBORA | 01/12/2013 | 22:47:00 | 0055|0004|00172631|00000047 | |
1010 | DEBORA | 06/12/2013 | 07:12:00 | 0055|0004|00172492|00000035 | |
2040 | KARINA | 04/12/2013 | 15:56:00 | 0055|0004|00172593|00000059 | |
5023 | MAGALI | 01/12/2013 | 19:30:00 | 0055|0004|00172627|00000011 | |
2456 | MARIA | 01/12/2013 | 11:16:00 | 0055|0004|00172621|00000031 | |
3333 | JORGE | 01/12/2013 | 14:46:00 | 0055|0004|00172627|00000017 | |
3333 | JORGE | 03/12/2013 | 18:22:00 | 0055|0004|00172633|00000033 |
I used this in the graphic function:
If(PatinetID=Above(PatinetID),DataEvent-Above(TOTAL DateEvent))
Like This?
Hi!
I linked this with the function "above" and could use in the graphic function.
Thanks!
Please close thread by selecting appropriate answer.
I used this in the graphic function:
If(PatinetID=Above(PatinetID),DataEvent-Above(TOTAL DateEvent))