- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Srubhi
Path Finder
06-23-2022
03:56 AM
We have data fields in the format, for example, 12Jun22 I need to format like 12-06-2022
as shown in the below table:
date | expected format |
12Jun22 | 12-06-20222 |
13Jun22 | 13-06-2022 |
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

richgalloway

SplunkTrust
06-23-2022
05:58 AM
Splunk has the strptime and strftime functions for that purpose.
| eval date=strftime(strptime(date, "%d%b%y"), "%d-%m-%Y")
---
If this reply helps you, Karma would be appreciated.
If this reply helps you, Karma would be appreciated.
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Srubhi
Path Finder
06-24-2022
03:40 AM
Thanks @richgalloway it worked!
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

richgalloway

SplunkTrust
06-23-2022
05:58 AM
Splunk has the strptime and strftime functions for that purpose.
| eval date=strftime(strptime(date, "%d%b%y"), "%d-%m-%Y")
---
If this reply helps you, Karma would be appreciated.
If this reply helps you, Karma would be appreciated.
