Converting Multiple Date format to one 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
dunkindonut7777
8 - Asteroid
‎08-28-2023
09:37 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I how to convert these dates in one column using formula tool.
Date | Expected Output |
2023-02-25 00:00:00 | 2023-02-25 |
6/21/2023 | 2023-06-21 |
Can you help me with this one pls.
Labels:
- Labels:
- Adobe
2 REPLIES 2
binuacs
21 - Polaris
‎08-28-2023
11:28 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@dunkindonut7777 One way of doing this
IIF(Contains([Date], "-"), DateTimeParse([Date],"%Y-%m-%d"), IIF(Contains([Date], "/"), DateTimePArse([Date],"%m/%d/%Y"), Null()))
ShankerV
17 - Castor
‎08-28-2023
11:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please use the below formula.
IF REGEX_Match(Left([Date],4),"\d{4}")
THEN DateTimeParse([Date],"%y-%m-%d")
ELSE DateTimeParse([Date],"%m/%d/%y")
ENDIF
Many thanks
Shanker V
