Thank you very much for the help. It works great but the fromat is slightly different. I'm guessing that only certain formats can be used in date fields, so that 'MM/DD/YY' is just not compatible with Designer? If that is the case then your script would be the answer I was looking for. If that i...