title: Selecting the most recent date from a table in PeopleSoft using Peoplesoft Query (Max() doesn't work)
body: <p>I am building a query in people soft using Peoplesoft query manager.  </p>
  
  <p>I am trying to pull the most recent date from the date column. I have tried using max() as an expression, however, the query doesn't pull any records. 
  I have checked with another co-worker and they have never been able to pull records using max(). </p>
  
  <p>Is there any other way or workaround to pull the most recent record?</p>