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 ! 🙂
Hi
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
Hi
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
Thank you for your help !
This work !