In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Date Time format to Time

AMDalton
5 - Atom

This feels as though it should be quite easy but here I am. 

I want to change date time to remove the date and keep the time. 

So

From

13/05/2024 12:30:00  

to 
12:30:00

4 REPLIES 4
alexnajm
18 - Pollux
18 - Pollux

Formula should work since it looks like it’s in a string format!

 

Regex_Replace([Field], “.+\s(.+)” , “$1”) 

 

OR 

 

Right([Field],8)

Qiu
21 - Polaris
21 - Polaris

@AMDalton 

We can also use the straightforwar approach DateTime Parse, or use the Space as delimeter. 😂

0215-AMDalton-A.png0215-AMDalton-B.png

 

kamal03
9 - Comet

Another way to do this is to use a formula tool.

 

AMDalton.png

aatalai
14 - Magnetar

If the data is already in time date format you could also put this into the formula tool

 

datetimetrim([field],'msec')

Labels
Top Solution Authors