• @john-2 , it would work but its not SARGable. Or at least the date is not, which is what we are interested in here.

    See the link i gave previously which describes this.



    Clear Sky SQL
    My Blog[/url]