topic Re: How can I only show rows from next 6 months based on the datestamp? in Getting Data In

How can I only show rows from next 6 months based on the datestamp?

rkassabov — Mon, 21 May 2018 19:12:10 GMT

I am trying to only show records that have "md_createdAt" fields that occur in the next 6 months, looking forward from that day's date. How would I only show these records?

|`init("xxx")`
| eval month=strftime(strptime(md_createdAt,"%Y-%m-%d %H:%M:%S.%6N"),"%b")
| table info_subType md_createdAt month
| chart count(info_subType) over month by md_createdAt

Re: How can I only show rows from next 6 months based on the datestamp?

somesoni2 — Mon, 21 May 2018 19:36:41 GMT

md_createdAt should be 6 month in future from today's date?

Re: How can I only show rows from next 6 months based on the datestamp?

rkassabov — Mon, 21 May 2018 22:13:12 GMT

thats correct

Re: How can I only show rows from next 6 months based on the datestamp?

somesoni2 — Mon, 21 May 2018 22:21:16 GMT

Just add following before |eval month.. line:

| where strptime(md_createdAt,"%Y-%m-%d %H:%M:%S.%6N")>now() AND strptime(md_createdAt,"%Y-%m-%d %H:%M:%S.%6N")<=relative_time(now(), "+6mon")

Re: How can I only show rows from next 6 months based on the datestamp?

rkassabov — Mon, 21 May 2018 23:24:06 GMT

That worked, thank you!

Re: How can I only show rows from next 6 months based on the datestamp?

DalJeanis — Tue, 22 May 2018 02:50:39 GMT

@rkassabov - We have converted the comment to an answer so you can accept it and the question will then show as closed. You can also (optionally) choose to upvote any comments or answers that you found particularly helpful. Thanks