3date fields and i only want to display the highest date of all three

[agray123]

IO have dept_entry_dt, job_entry_dt and position_entry_dt.

I want to create a formula that will show the greatest value of the three dates only.

The business case for this follows this logic -I could have entered a department 12-02-2001, then entered a new position 10-23-01 and finally was reclassed in my same position (to a new job) 03-12-2004.

Therefore 3-4-04 should display.

Can anyone help me out with this?

 

[vidru]

A formula like this should work:
[tt]
Maximum([{dept_entry_dt},{job_entry_dt},{position_entry_dt}])
[/tt]
-dave

 

[agray123]

thanks -it worked