I have a file where the dates are in dd-MMM-yy format. I thought I'd let SET DATE SHORT handle it for me, but no luck - I just got blanks back.

Even more amusingly, while DTOC(DATE()) shows the date the same way it is in the table, CTOD(DTOC(DATE())) fails the same way the table dates do.

Any thoughts on how to get this to work, or am I just going to have to reformat the dates before converting them?

Thanks.