how to search data created before last 14 Business days?

[wangzhaoyu]

I have a set of data with "submit date" like "2019-Jan-16 17:42:00". How can I get data submitted before 14 Business days? Thanks!

[mayurr98]

Hi Try this simple query

index=your_index latest=-14d@d earliest=0 NOT (date_wday=saturday OR date_wday=sunday)

let me know if this helps!

[dkeck]

HI,

do you want all data older than 14 days , or the data that came in on the 14th day before today?

[wangzhaoyu]

Hi,

I want the number of all data older than 14 Business days. thanks!

[dkeck]

try index=your_index latest=-14d@d earliest=0 | stats count

for a simple count

[wangzhaoyu]

Does "latest=-14d@d" mean last Business days? or last natural days? thanks!