>thank you,
>
>is there away to get the month as feb,,jan, oct.... only
>
>>>hi all
>>>
>>>*** ActiveX Control Event ***
>>>THISFORM.TEXT7.VALUE=TTOD(THIS.OBJECT.VALUE)&&result is 10/02/2008
>>>
>>>i need to convertit to 10-feb-2008
>>>
>>>thank you
>>
>>?Transform(THISFORM.TEXT7.VALUE,'@YL')
AFAIK you must code it
ldDate=THISFORM.TEXT7.VALUE
?Transform(Day(lddate)) + '-' + Left(Cmonth(ldDate),3) + '-' + Transform(Year(ldDate))