I want to split Value column in two column, one with Y-m-d and other with hour. I added the Text to column block and insert /s as delimiter but the second columns is not filled.
¡Resuelto! Ir a solución.
The delimiter should be \s and you need to have the [DATE LOGGED] field set to string.
A better solution might be using a Formula Tool and using the formulae,
ToDate([DATE LOGGED])
To get the time, you can just use the Select Tool and set the data type to Time.
I already insert /s and I don't take Data logged as reference but Action Date columns
Hi @elfunambolo
As @PhilipMannering mentioned the datatype should be string. Since it was date you were facing this issue.
I changed it to string in a select tool and its working fine now.
Hope this helps 🙂 Feel to ask if you have any questions
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi @elfunambolo
The date format present is "%Y-%m-%d" not "%Y-%d-%m"
You need to change "%Y-%d-%m" to "%Y-%m-%d"
hence you need to change it.
Hi @elfunambolo
Ignore previous
I found the exact error.
I think you need to set the date format same as condition.
This might be copy-paste typo.
Happy to help 🙂 @elfunambolo
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂