How to convert YYYYMM format Integer Column to Date Column

[Hide_Kojima1]

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

parse_character(order_date)

Then append “01” to the end

str_c(order_date, "01")

And change it to Date with ymd function

ymd(order_date)

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