Help Building a Record-to-Record comparison 1

[jenschmidt]

We are dealing with patient data and would like to calculate the amount of time between patient visits in order to make sure everyone is coming in as often as they should be. Example of data:

PtName PtNumber LastVisit TransactionNumber
Jane Doe 15 10/15/99 101452
Jane Doe 15 11/01/99 115438
Jane Doe 15 12/03/99 123546
Jane Doe 15 01/02/00 259877

How do I calculate the amount of time (in days) that has passed between each visit? jennifer.giemza@uwmf.wisc.edu

 

[IdoMillet]

Use the Previous({fld}) function to refer to the previous value.

For example,
--------------------------------------------------
IF Previous({PtName})={PtName} THEN
DateDiff("d", Previous({LastVisit}), {LastVisit}}
--------------------------------------------------

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

Try:

{MyTable.LastVisit} - Previous({LastVisit})

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[jenschmidt]

You guys are wonderful - Thank you very much! Just when I think I've learned as much as this brain can possibly hold, I learn something new - I just worry about old info that's falling out the other ear! jennifer.giemza@uwmf.wisc.edu