i've tried that. the thing is when i did the substring of "via CRM (28.09.2018 / 10:00:00-12:00:00)" to get only the date part i had to do: SUBSTR(t1.ATTRIBUTEVALUE, 10, 11) which is weird, since it has more than two characters, but the result is 28.09.2018. With that, how do i convert to date?
... View more