• It may be because the collation of the databases are different, one being say UK one being US, and the date is being entered not by a date field but by a text field so it needs to be formatted in the correct date format for the database. If the value was being inserted as a date correctly then the collation shouldn't make a difference, the database should handle it.

    Facts are stubborn things, but statistics are more pliable - Mark Twain
    Carolyn
    SQLServerSpecialists[/url]