• 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.