Splunk Search

change date format

ChetanArgekar
Explorer

HI,
I am receiving data from Solarwinds Server and it is in following format
November 27, 2019 8:34 AM
I need to convert it in to DD/MM/YYYY HH:MM format.
how to do this

Tags (1)
0 Karma

vnravikumar
Champion

Hi

Try this

| makeresults 
| eval test="November 27, 2019 8:34 PM" 
| eval result=strftime(strptime(test,"%B %d, %Y %I:%M %p"),"%d/%m/%Y %H:%M")
0 Karma

ChetanArgekar
Explorer

Thanks for help.
In worked

0 Karma

vnravikumar
Champion

Please accept the answer

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Wondering How to Build Resiliency in the Cloud?

IT leaders are choosing Splunk Cloud as an ideal cloud transformation platform to drive business resilience,  ...

Updated Data Management and AWS GDI Inventory in Splunk Observability

We’re making some changes to Data Management and Infrastructure Inventory for AWS. The Data Management page, ...