Thanks for the help guys. You were both right. Arthur, I just re-read what you wrote and a section about Picture Formats and get it now. No wizards for a user defined format. Ran a modified version of the little program based on what you posted. I selected the name of my format under user defined had a custom date / time. Works fine. Reeza, You were right about the datetime18. There is no need to change formats. I was following the end user's instructions on how they accomplish their manual process and mimicked their format change. It was an unnecessary step. Excel, SAS, and Access all spoke the same date time language if you just left everything alone. Now I know how to program for a custom format and don’t need it. My brain hurts.
... View more