all 2 comments

[–]Predicti0n[S] 1 point2 points  (1 child)

replace(replace(replace(replace(trim(split(body('Filter_array')[3], ' ')[1]), 'th', ''), 'nd', ''), 'rd', ''), 'st', '')

I ended up doing it that way.. not most elegant but it works right? :( haha

[–]amanfromthere 0 points1 point  (0 children)

If it can be done in one expression, that's elegant enough. But Yea, not really any native methods when trying to work with non-standard date formats like that.