How do I return latest date by employee as new script field or by filtering out older dates?
I'm loading employee data from an excel file (about 20 fields). One field displays review dates. For some employees there is more than one record. How do I return only the latest review date for them, or stop unrequired, older dates (for employees with more than one date) from being loaded at all? I thought firstsortedvalue might be the solution, but I can't get it to work.
In the example below, I want only the later date loaded into the script, or it can be returned in a new field.