Select By Attributes latest date from Data Table

Discussion created by Matt_R on Jul 30, 2013
Latest reply on Jan 30, 2015 by rfairhur24
Ok,  I'm having issues with what seems like a simple task.  I 'm trying to select the latest record from multiple facilities in a Table.  For example... the latest inspection record for City electrical transformers.  Ive tried the Sort Tool and Summarize tool - both are not working within the Model I'm building.  I was excited to see the expression for the select  by attributes tool below.  If anyone knows how to get this expression to work in Arc10, I would really be interested to hear how!  Ultimately I'll create a Feature Class Layer from the selection.

[mydate] in (SELECT max( [mydate] ) FROM table_name GROUP BY [groupID])