Help me to Format date

[rockts89]

Hi

I want to format the date field with the following format

Ex:

20190401

Expected:

01 Apr 2019 Mon

Thanks

[vnravikumar · Accepted solution]

Hi

Try like

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

[rockts89]

Thanks for quick reply..