>>from date date = 03/21/2001
>>
>>
>> D = day (date)
>>
>>
>> It returns 3
>>
>> How can I return 03
>>
>>
>> Thanks
>>
>> Moisés
>
>
>

>D=TRANSFORM(DAY(DATE),'@L 99')
>

As always, many ways to skin a fox. But I like the PADL() solution (that's the one I normally use). A quick unscientific timing of these functions in a loop showed PADL() to be over 40% faster. And using "@L 99", although there is nothing seriously wrong with it, looks to me a little '2.6ish'. <g>