Date format in a formula 1

[Scroller52]

Hi, running CR XI release 2 on a SQL DB

i have a formula that is based on a true/false parameter. this is how it reads:

if {?1st Year of Fund} = true then "CAPITAL COMMITMENT"
ELSE
"UNFUNDED COMMITMENT " & {Fund.Start Date}

if my 'start date' is 1/1/2007, the format of {Fund.Start Date} is: 1/1/2007 12:00:00AM

i want it to show as 'January 1, 2007' how can i do this?

 

[Crystaluser66]

Try using:
totext({Fund.Start Date},'MMMM d,yyyy')

 

[Scroller52]

thanks! thats what i was looking for.