topic Help me to Format date in Splunk Search

Help me to Format date

rockts89 — Wed, 03 Apr 2019 04:28:19 GMT

I want to format the date field with the following format

Ex:

20190401

Expected:

01 Apr 2019 Mon

Thanks

vnravikumar — Wed, 03 Apr 2019 04:30:17 GMT

Try like

| makeresults 
| eval date ="20190401" 
| eval epoch =strptime(date,"%Y%m%d") 
| eval new_date=strftime(epoch,"%d %b %Y  %a")

rockts89 — Wed, 03 Apr 2019 04:33:03 GMT

Thanks for quick reply..