string query = "SELECT DriverLabel AS Driver, Format(ReceivedDateTime, 'hh:mm:ss') AS MessageTime, FromPhone AS Phone, OriginalTextMessage AS Message FROM TextMessageLog where ReceivedDateTime=Date() ORDER BY ID DESC";
where Format(ReceivedDateTime, 'mm:dd:yy')=Format(Date(),'mm:dd:yy')
where Format(ReceivedDateTime, 'mmm:dd:yyyy')=Format(Date(),'mmm:dd:yyyy')
Open in new window