Splunk Search

I need to calculate the number of business days between two dates. Any help or direction on this will be very helpful.

yaminims
New Member

I need to calculate the number of business days between two dates. Any help or direction on this will be very helpful.

Tags (3)
0 Karma

jonuwz
Influencer

This :

| gentimes start=11/01/12 end=11/30/12 | search starthuman!="Sun*" starthuman!="Sat*" | stats count

This doesn't include 30th Nov, so if you want to include the end date in your calculation, add 1.

Also assumes non-business days start with 'Sat' or 'Sun'

Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...