Calculating Months

[bigblue]

I have two dates. The start date is 7/13/02 and the end date is 2/1/03. Is there a formula for Crystal 7.0 that can calculate the number of months including partial months between these two dates. I know the answer is 6.612 months. But I cannot figure out the formula in Crystal.

Thanks.

 

[synapsevampire]

I can't recall if CR 7 supports datediff, but that's the function in 8.X.

Try:

if not(onfirstrecord) then
datediff("m", Previous({MyTable.MyField}), {MyTable.MyField})

This would compare the previous date field to the current starting at the second row.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com