I need to export a date in the format yyyymmdd. It should not have any trailing time data, and if the month or the day is 1-9, it should appear as '01', '02', ...etc. There is the difficulty. I could create a few 'IF' statements of course, but I am hoping that there is a better, cleaner way to accomplish this export. It can be as a datetime or as a char() field.

Thank you in advance.

Rollin Burr
rollinburr@cox.net