topic Re: How do you build a chart from two date fields? in Getting Data In

How do you build a chart from two date fields?

gcescatto — Mon, 22 Oct 2018 11:37:51 GMT

On my current data I have two date fields: CommencementDate and CompletitionDate.
I would like to build a chart where the timestamp would be CompletitionDate - CommencementDate. For that, I created the query below:

| eval InspectionDate=strptime(CompletionDate, “%Y-%m-%dT%H:%M:%S”)-strptime(CommencementDate, “%Y-%m-%dT%H:%M:%S”) |

The date format is: 2015-01-27T06:00:00

Could someone please advise?

Re: How do you build a chart from two date fields?

richgalloway — Mon, 22 Oct 2018 12:55:28 GMT

You almost had it. Once you subtract the respective epoch times you just need to put the result back into text form.

... | eval InspectionDate=strftime(strptime(CompletionDate, “%Y-%m-%dT%H:%M:%S”)-strptime(CommencementDate, “%Y-%m-%dT%H:%M:%S”), "%Y-%m-%dT%H:%M:%S") | ...

Re: How do you build a chart from two date fields?

gcescatto — Mon, 22 Oct 2018 16:53:23 GMT

Hi richgalloway (:

I did try using the updated query you provided me, but I’m still not getting any results for InspectionTime... any other inputs? 🙂