topic How to change date format multiple time in Getting Data In

How to change date format multiple time

fatanyk — Mon, 26 Sep 2022 12:42:07 GMT

Hello,

I'm trying to change my date format two times because i want to sort to order my month from January to December.

I've been trying this search but the field newPeriode2 isn't showing any results :

| eval newPeriode = strftime(strptime(Période,"%Y-%m-%d"),"%m-%Y")
| sort newPeriode
| eval newPeriode2 = strftime(strptime(newPeriode,"%m-%Y"), "%B-%Y")

this is what it looks like. I want my newPeriode2 looks like : January-2022 etc...

Thanks for your help ! 🙂

Re: How to change date format multiple time

isoutamo — Mon, 26 Sep 2022 13:01:38 GMT

just convert it to epoch and then sort

| eval newPeriode = strptime(Période,"%Y-%m-%d %H:%M:%S") | sort newPeriode | eval newPeriode2 = strftime(newPeriode, "%B-%Y")

As epoch is a integer it will sort time correctly. Then just convert it back to you desired format.

r. Ismo

Re: How to change date format multiple time

fatanyk — Mon, 26 Sep 2022 13:15:35 GMT

Thank you for your help !

This work !