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


Thanks for the timing info ... I'll tuck that in my memory!

Cathy