Thanks, I think that is getting me close. The one question I had was does this do the date add all the time? I only need to do it if...

to be a little clearer it's only the year that I have to fix in the following format

3/8/2007

thanks

Yes, the system date would work, but I'm not sure how to get it in the field?

Thanks. I understand the concept, I just need to get my mind around the scripting.

Thanks, and yes the tables already exist in the destination database. I was thinking along the same lines that the order might be important but have to admit that I'm...