https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56216#M13744 <PRE><CODE>...| eval start = strptime(date1, "%Y-%m-%d %H:%M:%S")| eval end = strptime(date2, "%Y-%m-%d %H:%M:%S")| eval duration = round((end-start)/86400) </CODE></PRE> <P>Converts column to timestamp(epoc): strptime(field, date_format)<BR /> This will give you the duration in days (example): 23</P> Fri, 08 Jul 2016 20:42:01 GMT singhh4 2016-07-08T20:42:01Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56209#M13737 <P>Please give a solution to calculate the number of days between two given dates..</P> <P>Regards<BR /> Govind.</P> Mon, 21 May 2012 02:52:37 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56209#M13737 jgr_26 2012-05-21T02:52:37Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56210#M13738 <PRE><CODE>... | eval (timestamp2-timestamp1)/86400 </CODE></PRE> <P>is whatI can do with the information you've given.</P> Mon, 21 May 2012 05:15:26 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56210#M13738 gkanapathy 2012-05-21T05:15:26Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56211#M13739 <P>You really need to provide more context on this, such as, where are these dates coming from?</P> Mon, 21 May 2012 05:16:10 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56211#M13739 gkanapathy 2012-05-21T05:16:10Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56212#M13740 <P>i need to generate a time based report. Below are the inputs<BR /> Start Date : string<BR /> End Date : string</P> <P>I need the no of days from ( now to startDate) and (now to endDate), so that i can play around.</P> <P>Thanks</P> Mon, 21 May 2012 15:23:30 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56212#M13740 jgr_26 2012-05-21T15:23:30Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56213#M13741 <P>This is not working.... </P> <P>Here is my scenario... I have event coming in SPLUNK from database and i have 2 date columns in it. I need to get the difference between the 2 days and want to filter all records that are greater than 30 days.</P> Wed, 21 Nov 2012 17:32:54 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56213#M13741 jebasinghk 2012-11-21T17:32:54Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56214#M13742 <P>Ok, so what's not working with the provided solution?</P> Wed, 21 Nov 2012 22:18:39 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56214#M13742 Ayn 2012-11-21T22:18:39Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56215#M13743 <P>Hi , <BR /> source="dmon-tail://idhouse/id_account" application=TFD [|inputlookup execSSO.csv |rename sso as owner] |eval exp_date=strftime(relative_time(strptime(lastPasswordChange,"%Y-%m-%d %H:%M:%S"),"+90d@d"), "%Y/%m/%d %H:%M")</P> <P>This query is working good . </P> <P>I need one more help , </P> <P>I want to count the days between exp_date and today date</P> <P>any one can help me on this ...</P> <P>Thank u ,</P> <P>Regards,<BR /> Siraj</P> Mon, 28 Sep 2020 17:45:56 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56215#M13743 siraj198204 2020-09-28T17:45:56Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56216#M13744 <PRE><CODE>...| eval start = strptime(date1, "%Y-%m-%d %H:%M:%S")| eval end = strptime(date2, "%Y-%m-%d %H:%M:%S")| eval duration = round((end-start)/86400) </CODE></PRE> <P>Converts column to timestamp(epoc): strptime(field, date_format)<BR /> This will give you the duration in days (example): 23</P> Fri, 08 Jul 2016 20:42:01 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56216#M13744 singhh4 2016-07-08T20:42:01Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56217#M13745 <P>HI, Just a small question here: What if I want to remove the weekend from this calculation. </P> Tue, 04 Sep 2018 07:43:33 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56217#M13745 Chandras11 2018-09-04T07:43:33Z https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56218#M13746 <P>hi @Chandras11 </P> <P>have a look into this links:-</P> <P><A href="https://answers.splunk.com/answers/306182/how-to-exclude-weekends-saturday-and-sunday-from-a.html">https://answers.splunk.com/answers/306182/how-to-exclude-weekends-saturday-and-sunday-from-a.html</A></P> <P><A href="https://answers.splunk.com/answers/426673/how-to-filter-out-weekdays-or-weekends-in-one-sear.html">https://answers.splunk.com/answers/426673/how-to-filter-out-weekdays-or-weekends-in-one-sear.html</A></P> Tue, 04 Sep 2018 07:50:25 GMT https://community.splunk.com/t5/Splunk-Search/To-find-number-of-days-between-two-dates/m-p/56218#M13746 harishalipaka 2018-09-04T07:50:25Z