Combine split and get in a formula

Cancun_Mx

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

Catalina

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:

 

Cancun_Mx

Hi Catalina,

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

Thanks a million.

HP