Return Max Creation Date
SummaryReturn Max Creation Date
Requirement is to only return the Max (Latest) Creation Date of comments entered in the Requisition Comments field, e.g. If we have two comments 1st dated Aug 22, 2016 and the last comment was entered Aug 30, 2016 we only want to return the comment dated Aug 30, 2016.
Any ideas of how this can be done?
|Location||Requisitions - Status||Job Title||Hiring Manager||Justification||# Live Roles||Days Open||Employment Type||Recruiter||Position Number||Job Code||Comment Entered By||Latest Comment||Creation Date|
|HO||Open||TEST TEST||Manager, Hiring||eeeeeeeeeeeeeee||1||7||Permanent||Adminisrator, Test HR||test||Test||charmaineh||Second Comment|