most recent date out of several fields

[sambha]

How can I create a date field (called latest date), such that the field will evaluate a known set of dates (date1, date2, such that it will pick the date that is the most recent and populate the 'latest date' field with it. The 'latest date' may be 'date 1' for one record, but it could be 'date 9' for another record. Thanks so much.

Thanks edited, i figured it out, I was using the max command improperly, it works now

Edited May 2, 2010 by Guest