• Yes the way tmorton suggested is certainly better. I got too caught up with using DATEPART and failed to find a simpler way.

    Robert Marda

    Robert W. Marda
    Billing and OSS Specialist - SQL Programmer
    MCL Systems