In Sage 100, I am attempting to select the earliest and latest dates from the completed date column on the work order scheduling tab. I need to do this via an SQL table. Currently, I am using the following calculation: [SELECT srvsch.findte FROM srvsch WHERE srvsch.recnum = {srvinv.recnum} AND srvsch.linnum = 1] to select the date associated with the top line of the table. Obviously, it is not always accurate to assume that this line is chronologically first. Additionally, I have no idea how to determine which line is chronologically last. Any help would be greatly appreciated.