Try posting the actual format rather than a description.
I'll guess that it has YYMMDD, so try:
stringvar MyYear:=mid(totext({table.field},0,""),1,2);
stringvar MyMonth:=mid(totext({table.field},0,""),3,2);
stringvar MyDay:=mid(totext({table.field},0,""),5,2);
If val(Year)> 50 then
cdate(1990+val(year),val(month),val(MyDay))
else
cdate(2000+val(year),val(month),val(MyDay))
If you don't know what a field contains, right click it and select Browse Data, it will show you the data type and it's format.
-k