datepart always returns January ?

[JumpinJimRivers]

I'm not see why the following always returns January:

Format(DatePart("m",[mydatefield]),"mmmm&quot

It's supposed to take only the month from mydatefield, which is formatted as mm/dd/yyyy, and reformat it as "mmmm" so, for example, if 7/01/2002 was in mydatefield it would enter "July" where I have the formula. But it's only returning January...anybody know what I'm doing wrong?

Thanks

 

[lameid]

Format([mydatefield],"mmmm&quot

 

[FancyPrairie]

This should work: format([mydatefield],"mmmm&quot

 

[JumpinJimRivers]

it works, thank you!