>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.
It (?CTOD(DTOC(DATE()))) only fails for me with SET DATE LONG. Any other setting seems to work. (VFP9/SP1)