I need the syntax in SQL (or Criteria) to find the most recent date in a table. table contains IssueID, ProgressLog, and ProgressUpdateDate. I am trying to get most recent ProgressUpdateDate inthe table. IssueId can have more than one progressLog. I need to get most recent progressupdatedate and progresslog in the table.

thanks in advance

Pretty Gal