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