Including latest applicant tracking comment in candidate report

Content

I am working on a report for recruiters to use when updating hiring managers of requisition status.  We are including certain candidate information and would like to include comments entered by recruiters on the applicant tracking tab.  We would only need the latest comment.

I think this can be done by pulling in comments and the date the comments were entered and then writing a variable to include only the comment with the most recent date, but my attempts aren't working exactly as I would like them to.  The latest variable I tried was to a where statement to include the comment where the minimum of the current date minus the comment date, but something is wrong with my syntax.