Change date to month in ACCESS

[bwlytkr]

I have a Complete Dt column with the date formatted as 10/8/2019 and I need a formula to convert this to the name of the month. Any ideas? I tried this but all I get is January in the column.


Format(DatePart("m",[Completed Dt]),"mmmm")

 

[Norie]

Try this.

Format([Completed Dt],"mmmm")

 

[bwlytkr]

Great!! Thanks.. I tried that but, I was leaving the ) after the Completed Date was why it didn't work. Thanks again.