I'm only able to query a date by ">=" but I want to only query a specific date and removing ">" gives me a no results found message even though there is a record with that date. Can anyone help?
Here is what works:
Date_of_Issue BETWEEN timestamp '2017-05-21 00:00:00' AND timestamp '2017-05-21 23:59:59'
This queries the Date_of_Issue field for any record on the Whole 24 hour period of May 21, 2017
or more like your original attempt:
Date_of_Issue >= timestamp '2017-05-21 00:00:00'
I was able to get this to work after modifying your query:
Date_of_Issue BETWEEN timestamp '2017-05-20 23:59:59' AND timestamp '2017-05-22 00:00:00'
Retrieving data ...