Hi,
I would like to know how to calculate the number of days between 2 admissions. Here is my records look like:
ClientID admissionDate DischargeDate
0001 1/1/2004 1/3/2004
0001 1/4/2004 1/10/2004
0001 1/20/2004
how can I make it looks like:
ClientID admDate DischrgDate Re-admDate #ofdays
0001 1/1/2004 1/3/2004 1/4/2004 1
0001 1/4/2004 1/10/2004 1/20/2004 10
Thanks in advance.
I would like to know how to calculate the number of days between 2 admissions. Here is my records look like:
ClientID admissionDate DischargeDate
0001 1/1/2004 1/3/2004
0001 1/4/2004 1/10/2004
0001 1/20/2004
how can I make it looks like:
ClientID admDate DischrgDate Re-admDate #ofdays
0001 1/1/2004 1/3/2004 1/4/2004 1
0001 1/4/2004 1/10/2004 1/20/2004 10
Thanks in advance.