Parse string to date using 'Custom Dimensions'

[rsingh]

Hi Team

We have a column in database that is a string format of date eg: “2022-01-19T00:00:00+00:00” and we like to find to way to convert it into “date” using custom dimension on Looker Explore so that our clients can filter it as regular dates.

The condition here that we only need it on Explore (not LookML) because the underlying field is Dynamic (it can be “2022-01-19T00:00:00+00:00”, “123”, “abc”) based on the client so we like to have this flexibility on Explore level and not hard code on LookML,

Please advise