My query feeds into a DataGridView which is why I rename the columns:
string query = "SELECT DriverLabel AS Driver, ReceivedDateTime AS MessageTime, FromPhone AS Phone, OriginalTextMessage AS Message FROM TextMessageLog ORDER BY ID DESC";
1) But I'd like to format the ReceivedDateTime to only show the time, and truncate the date.
2) I'd like to filter the query results for today only.
So I am a bit stuck on these two issues. Please let me know if you have ideas how to fix them.