SOLVED
Extracting Date
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
KamenRider
11 - Bolide
‎11-15-2023
12:35 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Can I ask for your assistance in extracting the date. Below is my example.
BACKLN Driving (12.08.2021).xlsx --- results should be 2021-12-08
CACLN Driving (10.31.2023).xlsx --- results should be 2023-10-31
I have this formula but it give me a null results. -- DateTimeParse(REGEX_Replace([FileName], '.*?_(.*?)_.*', ''),'%Y%m%d')
Hope you could help me on this. Thanks,
Kamen
Solved! Go to Solution.
Labels:
2 REPLIES 2
CoG
14 - Magnetar
‎11-15-2023
12:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
DateTimeParse(REGEX_Replace([Field1], ".*?(\d{2}[.]\d{2}[.]\d{4}).*", "$1"),"%m.%d.%y")
binuacs
21 - Polaris
‎11-15-2023
01:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)