itortu (5/26/2015)
This did the trick for me:SELECT orderno
FROM _order
WHERE CAST(FLOOR(CAST(order_date AS FLOAT)) AS DATETIME)
BETWEEN CAST('5/14/2015' AS DATETIME)
AND CAST('5/15/2015' AS DATETIME)
ORDER BY order_date asc
The date will come always in the format mm/dd/yyyy
Many thanks
This will return all records from 05/14/2015 00:00:00 up to AND including 05/15/2015 00:00:00.