Convert Yearmo to Date

Q&A
1

I have a column yearmo (eg. 202303) and I want to convert that to date format in quicksight. How can I do that?

2

parseDate(concat(substring(‘202303’,1,4),‘-’,substring(‘202303’,5,2),‘-01’),‘yyyy-MM-dd’)

Substitute ‘202303’ with your date field.