topic Re: date format in Dashboards & Visualizations

date format

owulz — Sat, 13 Feb 2021 13:43:59 GMT

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 — Sat, 13 Feb 2021 15:21:26 GMT

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 — Sun, 14 Feb 2021 07:32:42 GMT

Thanks so much @manjunathmeti !

manjunathmeti — Sun, 14 Feb 2021 14:37:41 GMT

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