• So...

    WHERE [Product Date] >='20120811' and [Product Date] <'20120819'

    will do you, you dont need to ignore the time, just adjust the search arguments to match your data



    Clear Sky SQL
    My Blog[/url]