I'm sorry to say that I am not surprised at your solution. More and more I find work-arounds resorting to Access. Not an optimal solution when in an Enterprise Data environment yet the functionality it can seamlessly perform is still lacking in the Enterprise apps. Integrated date formatting is indeed a major sore point between SQL Server, SSIS, and the Microsoft Office applications.

If I ever get the hack I have in mind to work, I will be sure to let you know. Deal?

~ MJ