Splunk Search

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

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

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'

State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!