Also, don't use a UDF to convert dates to YYYYMMDD, just CONVERT(char(8),YourDate,112).  The native function (and implicit conversion if the result is going into an int column) will be faster than any UDF, and you'll appreciate this speed if you're actually updating an entire table.

True. Didn't see the 112 in the list.....