How to convert YYYYMM format Integer Column to Date Column

Suppose you have column that have data

And this is YYYYMM data and you want to convert it to Date Column.

So first you convert the column to text column


Then append “01” to the end

str_c(order_date, "01")

And change it to Date with ymd function


And now order_date column is converted to Date data type column.