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
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.