in reply to date reformatting

Howdy!

You could use the convert function in your SQL to return it as a string in a whole variety of formats, including mm/yy/dd.

Yeah, it's not a direct answer to your question, but it might be simpler.

yours,
Michael