Get Highest date in record

[nickedw0]

I need to compare the intra record values of 3 date fields and assign  that value to a new field. 

Something like maximum of (Chargedate, ChangeDate,ResolvedDate) As LastChangeDate

[ahaahaaha]

Hi,

May be

RangeMax(Chargedate, ChangeDate,ResolvedDate) As LastChangeDate

Regards,

Andrey