datetime formula

[luxvivens]

I have a “datetime” field that I wish to use to derive time difference in military hours.
Perhaps datedifference is the syntax to use.
An example of my data is:
John Doe
2/8/2013 5:50:00
2/8/2013 8:51:00
2/9/2013 14:44:00
Sally Smith
2/9/2013 20:20:00
2/10/2013 10:05:00
2/11/2013 16:45:00
My report is sorted by patient name and then by datetime.
Need help, please, with formula that will display 181, for example, in the second row of John Doe and so on.
I realize there won’t be a value for the first datetime for a patient.
I am using Crystal 10.

 

[pmax9999]

Try this:

Create this formula:

If      {Data.PatientName} = Previous({Data.PatientName})
Then    DateDiff('n', Previous({Data.DateTime}),{Data.DateTime})

Hope this helps

Cheers
Pete

 

[luxvivens]

Thanks Pete, and sorry about my very tardy response. It works