Change date to month in ACCESS

bwlytkr

Board Regular
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")
 

bwlytkr

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

Some videos you may like

This Week's Hot Topics

Top