Date Time format to Time
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
AMDalton
5 - Atom
02-14-2024
03:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Date Time
4 REPLIES 4
18 - Pollux
02-14-2024
03:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Formula should work since it looks like it’s in a string format!
Regex_Replace([Field], “.+\s(.+)” , “$1”)
OR
Right([Field],8)
21 - Polaris
02-14-2024
03:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We can also use the straightforwar approach DateTime Parse, or use the Space as delimeter. 😂
kamal03
9 - Comet
02-14-2024
09:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
aatalai
14 - Magnetar
02-15-2024
02:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
If the data is already in time date format you could also put this into the formula tool
datetimetrim([field],'msec')
