Maximum Day Range

[EllenM]

Hello,
I'm looking for the maximum day span. I'm using

"=Max(DateDiff("d",[LAST DATE FILED],[DATE FINAL RULE EFFECTIVE]))"

in my control box, but it's giving me a day range a bit smaller than the
largest date difference in my list.

Can someone help me?

Thanks,
Ellen

 

[EllenM]

Hi All,
My formula is fine. There was a mistake elsewhere.