select ot.KEYFIELD, ot.CUST_ID, ot.ORD_DATE, ot.ORD_TIME ;
from ORDERTABLE ot;
where KEYFIELD =
	(select top 1 KEYFIELD from ORDERTABLE sot
	where sot.CUST_ID == ot.CUST_ID
	order by sot.ORD_DATE, sot.ORD_TIME descending where sot.ORD_DATE=yourDate)
order by CUSTOMER