SOLVED
Extract Date & Time from a field
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
udles5666
8 - Asteroid
‎09-09-2020
09:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi community
I am trying to extract date & time from a field.
Can someone please help me with it? Attached for reference.
Thanks in advance
Field:
9/09/2020 7:28:56 p.m.
Extract:
Date in dd-mm-yyyy format
Time in HH:MM:SS am/pm format
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
3 REPLIES 3
17 - Castor
‎09-09-2020
09:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @udles5666 ,
Here is a solution for you. I was not sure about your date format, so I've used M/D/Y format.
Best,
Fernando Vizcaino
grazitti_sapna
17 - Castor
‎09-09-2020
09:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
grazitti_sapna
17 - Castor
‎09-09-2020
09:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@udles5666 , I have made a slight change converted the exact date into dd-mm-yyyy format. Refer to this file.
Thanks.
Sapna Gupta
