I have a data frame with where one of the columns contains a string “date code”. An example of this code is as follows: “04_22” which indicates the 4th month of the year 2022. “11_23” would indicate the 11th month of 2023. Rather than working with this code in string, I would like to convert th…

[image] Nash: but always the last day of the month Maybe you could do: Date.(vd, "mm_yy") .+ Year(2000) .+ Month(1) .- Day(1)

Convert string "date code" for month and year to proper date type

rafael.guerra July 20, 2022, 6:48am 8

Maybe you could do:

Date.(vd, "mm_yy") .+ Year(2000) .+ Month(1) .- Day(1)

1 Like

Topic		Replies	Views
Most efficient way: create/mutate DataFrame time column General Usage	8	1116	November 28, 2019
Alter Date List in dd/mm/yyyy format to yyyy format General Usage	4	682	August 16, 2020
Parsing a CSV file with 2-digit year New to Julia	3	1758	September 13, 2018
String to Date New to Julia dates	4	918	April 20, 2022
Convert string months (January, February, March, etc.) to date format New to Julia dates	1	407	July 19, 2022