Combine split and get in a formula

Cancun_Mx
Level 1
Combine split and get in a formula

Hello everybody, it's my first post on the comunnity. I've a question, I try to alterate a column its save a dates in format dd/MM/yyyy HH:mm:ss, and I want it to split for get the hour, I tried with asDate, get and split but unsuceess. Somebody to help me.

Thanks in advance.

HP

0 Kudos
1 Reply
CatalinaS
Dataiker

Hi @Cancun_Mx

You can use a Prepare recipe to parse the date into a standard format and then extract the hour using Extract date elements step:

Screenshot 2023-02-16 at 19.34.37.png

0 Kudos