How to pull out the first entered and last entered values for experience

Content

Hi All,

So I am trying to write a report where I am looking to display the current or last job that someone is/was in. The problem that I am having here is that some applicants have filling in their profiles first making their most recent experience the highest display sequence instead of the 1st display ssequence. I tried created a custom variable that returns the max display sequence and use the start date of employment to do a compare and placed a where statement in there to look at where it was most recent. The issue that I am having is