comparing two date fields 1

[crachic]

I need to write a formula and I am not sure where to start. I need the formula to accomplish the following:

if the admit date of an episode is less than or equal to 7 days after the discharge date of the previous "same type" episode put an X. The discharge date is inclusive, meaning that the discharge date of the previous episode counts as one of the seven.

By "same type" i mean that there are three different types of episodes and the only type I am concerned with it the one where the code is I.

I am using Crystal XI.

Thanks,
-crachic

 

[lbass]

Why not use a record selection so that the only type displayed in the report is "I"? Then assuming an ascending sort on date, you could just use a formula like this:

if {table.patient} = previous({table.patient}) and
datediff("d",previous({table.date}),{table.date}) < 7 then "X"

-LB