topic Re: Multiple time format in the same field in Dashboards & Visualizations

Multiple time format in the same field

mah — Thu, 11 Mar 2021 13:36:04 GMT

Hi,

I have a field which contains epoch date and date time like %Y%m%d :

mah_0-1615469377850.png

I want this format %Y%m%d for all values in "date" field.

How can I convert epoch to date like %Y%m%d in this field ?

Thanks !

manjunathmeti — Thu, 11 Mar 2021 14:11:37 GMT

hi @mah,
Try this:

| eval date=if(match(date, "\d{4}\-\d{2}\-\d{2}"), replace(date, "-", ""), strftime(date, "%Y%m%d"))

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

mah — Thu, 11 Mar 2021 15:32:06 GMT

I tried your solution and it gave me this :

mah_0-1615476507681.png

20210201 = 22-08-1970 : there is a problem ...

I tried another command :

| convert timeformat="%Y-%m-%d" mktime("date")

and thant's worked ! All values in %Y-%m-%d format are converted to epoch time !

Thanks for your help !

manjunathmeti — Thu, 11 Mar 2021 15:42:17 GMT

Did you wanted Date field values in "%Y%m%d" OR in epoch format?