Peter,
Would this work for you
ldDate = DATE()
? LEFT(CMONTH(ldDate),3) + " " + ;
PADL(DAY(ldDate),2, "0") + ", " + ;
TRANSFORM(YEAR(ldDate))
>
>I am looking for ma way to reformat the date in one of my fields.
>
>example
>I data comes in like 12/01/04 and I want it to look like Dec 01, 2004
>
>
--sb--