Convert character into date format

Question

I currently have a database with dates in character format yyyy-mm format. e.g. 2009-01 and missing values.

I'm struggling to convert this into a date format.

Answer 1

You could use ym from lubridate package:

lubridate::ym('2009-01')
#[1] "2009-01-01"