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
From13/05/2024 12:30:00
to 12:30:00
Formula should work since it looks like it’s in a string format!
Regex_Replace([Field], “.+\s(.+)” , “$1”)
OR
Right([Field],8)
@AMDalton
We can also use the straightforwar approach DateTime Parse, or use the Space as delimeter. 😂
Another way to do this is to use a formula tool.
If the data is already in time date format you could also put this into the formula tool
datetimetrim([field],'msec')
