date format

[owulz]

Hi I have two date fields that show up in my dash board panel that lists events after visualisation panels.

"2021-11-02 16:53:38" and "11/02/21 at 16:52:37"

I am trying to find a way to reformat the second date (right) to be like the first.

YYYY-MM-DD hh:mm:ss

Is there an easy way?

This is a search query inside a table listing.

Thank you

[manjunathmeti · Accepted solution]

hi @owulz,

Use strptime and strftime functions.

| eval seconddatetime=strftime(strptime(seconddatetime, "%d/%m/%y at %H:%M:%S"), "%Y-%d-%m %H:%M:%S")

If this reply helps you, an upvote/like would be appreciated.

[owulz]

Thanks so much @manjunathmeti !

[manjunathmeti]

You're welcome! You can accept the answer and give it a thumbs up.