How to get days and records between events?

[#1]

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

[MK_QSL]

Like This?

[#3]

Hi!

I linked this with the function "above" and could use in the graphic function.

Thanks!

[MK_QSL]

Please close thread by selecting appropriate answer.

[#5 · Accepted solution]

I used this in the graphic function:

If(PatinetID=Above(PatinetID),DataEvent-Above(TOTAL DateEvent))