Hi. My view has a field with timestamp. Although, the field type is "text". I really only want to get a date from the field, but I don't know how.
Here is an example of the text field:
I need to be able to join this to another view on date. The other view has a date in the following format: 2020-05-05 (returned using to_localdate on a timestamp field). Ideally, I'd like to be able to get the text field above to return a date in similar format: 2019-12-21, 2019-10-02.
I thought I would try to_localdate or to_timestamp. But, I think I'm getting the expression wrong due to the way the text is formatted (things I tried):
I'd appreciate any suggestions.