[jelzin]

I try to create a custom column that contains a date value from the tags column. The format of that tag is 'year-month-day' (where the month and day will be padded with 0 to length 2) eg. 2021-03-15.

I tried this function to get it but it's not working and i can't figure out why (could be the regex or i'm using the wrong function here or all those ' are canceling themselfs out somehow?):

{:'list_re(field('tags'), ',' ,'\d{4}-\d{2}-\d{2}')'}

Would be nice if someone could help me out with this one.

The next problem will be to create a hierarchy from that date field:
Year.Month.Day

I know i could easily create an custom column with a hierarchy but i try to use the default columns and create automated custom columns from those.

Thanks,

Johan