Convert string months (January, February, March, etc.) to date format

I have a database where one of the columns contains the strings for months spelled out in english and the first letter capitalized (January, February, March, etc.). How do I convert the column to a date format?

You can use the U date format specifier (see docs for DateFormat):

julia> using Dates

julia> Date("January", dateformat"U")
0001-01-01

julia> Date("March", dateformat"U")
0001-03-01
3 Likes