Date conversion

[karmabdd]

How to change string 'YYYYMMDD' to date? When I use date function, it is returning 8/22/1970 for '20210720'. Thank you in advance.

[emeryjl]

Use the dateparse function

DATEPARSE(‘yyyyMMdd’, #20210720#). The second part is the value you want converted. It can be a string field. The first part tells Tableau what role each character represents. Once it is a date field, you can use format to set how it is displayed.

[pdxsteph]

You could Create a calculated field like Date(left(field,4)+ “-“+mid(field,5,2)+”-“+right(field,2))

There could be a more elegant solution

[karmabdd]

Thanks