I have the below table and when i run this query:
SELECT * FROM table1 WHERE Date <= "11/15/2018 12:00:00 AM"
it only retrieves the dates 15,14,13,12,11,10 and 1 of Nov 2018 . How can i solve this? Thanks!
I tried changing the format of the date in the
WHERE part of the query to
"11/15/18 12:00:00 AM", it doesn't work.