SOLVED
Date and Time format
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
Athilingam_S
7 - Meteor
‎08-03-2021
12:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Experts
Please guide me how can i change the below data exact date and time format
16-AUG-2020 03:05:48 |
27-JUL-2021 19:27:23 |
29-JUL-2021 17:23:51 |
29-JUN-2018 18:43:29 |
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
4 REPLIES 4
Jean-Balteryx
16 - Nebula
‎08-03-2021
12:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Athilingam_S ,
You can do it using the following expression in a formula tool :
DateTimeParse([Date], "%d-%b-%Y %H:%M:%S")
The DateTimeParse function transforms a string in the specified format into a date field.
I attached the workflow.
ArtApa
Alteryx
‎08-03-2021
04:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-03-2021
10:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Jean Balteryx
Thank You
‎08-03-2021
10:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes its really help Thank you