>>>Sorry, Terry.
>>Magnetism and my password :-)
>
>Don't understand you, what do you mean?
Boy it's sure is warm for this time of year in houston.
>
>BTW, quick question (I'll start new thread also):
>I have a Date field. Century is on.
>I want a character field in this format: 1/1/80, 11/23/01, etc.
>
>What's the simplest way to do it? Also since this date is already a result of long function, I don't want to invoke it multiple time.
>

iif(vartype(oJC)='O' and oJC.CurState='MA',dtoc(GetDescription(TOWN,'FilingDate','Town'),'LandCt_Fm'),'')

>
>In theory, though, I can write another function, say, ConvertDate(tdDate), so it'll solve my problem.
Maybe,
sdate=dtos({^2001-1-1})
? alltrim(str(val(substr(sdate,5,2))))+[/]+alltrim(str(val(right(sdate,2))))+[/]+right(left(sdate,4),2)