updating the query syntax, column filtering for date/time