Calculation to find latest date

[sdcagle]

This is most likely easy but....

I have three dates fields for our school's immunization records, DPT, DT & Tdap. I need a field that evaluates those three fields and is filled with the latest date. Currently I use the following calculation to evaluate two fields:

If(Max (mr_DPT) > Max (mr_DT); Max (mr_DPT); Max (mr_DT))

Thanks,

Scott

[LaRetta]

You are close, Scott. You can easily find the latest date with:

Max ( mr_DPT ; mr_DT ; Tdap )

Make the result of the calculation type date.

[sdcagle]

Thanks, LaRetta. I figured I was over-thinking. That works great.

I appreciate the quick response.

Cheers.