Jump to content
Sign in to follow this  
sdcagle

Calculation to find latest date

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

I appreciate the quick response.

Cheers.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.