topic Re: How to get data by comparing with a date field and current date in Dashboards & Visualizations

How to get data by comparing with a date field and current date?

dtccsundar — Tue, 21 Feb 2023 15:04:38 GMT

We have different licenses expires by different dates .The current sourcetype data comprises of both future expiry and past expiry too.

we don’t want license that are expired meaning anything that is before the current day.

"Expire valid To" field will have this date .

Please let me know how to achieve this in SPL .

Re: How to get data by comparing with a date field and current date

bowesmana — Mon, 20 Feb 2023 06:03:10 GMT

Here's a simple example that generates 20 dates within one year before or after today and makes that date YYYY-MM-DD.

The where clause simply checks that date is >= today

| makeresults count=20 ``` Make up a random sample of expiry dates within 1 uyear before and after today ``` | eval r=365 | eval range=random() % (r * 2 * 86400) | eval "Expire valid To"=strftime(now() + (r * 86400) - range, "%F") ``` Now simply test whether the expiry date is today or later ``` | where strptime('Expire valid To', "%F") >= relative_time(now(), "@d")

The last line is what you will need. Depending on your date format, change the strptime format variable (currently %F is YYYY-MM-DD).

Re: How to get data by comparing with a date field and current date

dtccsundar — Mon, 20 Feb 2023 09:41:01 GMT

It works bowesmana .Thank you .