• just get rid of the time part on the input and sample dates.

    Method1

    casting as int

    Cast(@inputDate1 as int)

    Method2

    remove time part

    @newinputdate = Cast(Convert(varchar(10),@inputDate, 101) as datetime)

    Method3

    you could use acombination of DateDiff using 'd' as the difference

    HTH


    * Noel