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