@Lucas search for an SO by customer, sort by the date you're interested in, the first would be the one you want if the sort is ascending?