>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.

SET DATE SHORT
lcMonths = [JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC]
lcDate   = DTOC(DATE())
lnDay    = VAL(LEFT(lcDate,2))
lnYear   = VAL(RIGHT(lcDate,4)) && Change 4 to 2 if you have only last two digits from the year
lcMonth  = UPPER(SUBSTR(lcDate,4,3))
lnMonth  = INT((ATC(lcMonth,lcMonths)/3))+1
? DATE(lnYear, lnMonth, lnDay)