Combine split and get in a formula

Cancun_Mx
Level 2
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
2 Replies
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
Cancun_Mx
Level 2
Author

Hi Catalina,

Sorry for the delay. Indeed, I resolved written a formula on dataset.

Thanks a million.

HP

0 Kudos