https://community.splunk.com/t5/Splunk-Search/Splunk-Query-help-to-find-time-difference/m-p/469276#M132061 <P>For last 30 days(which i will select in time filter) I would like to get the count of field X only if it is older than 7days from current time.</P> Thu, 24 Oct 2019 16:53:32 GMT NAVEEN_CTS 2019-10-24T16:53:32Z https://community.splunk.com/t5/Splunk-Search/Splunk-Query-help-to-find-time-difference/m-p/469276#M132061 <P>For last 30 days(which i will select in time filter) I would like to get the count of field X only if it is older than 7days from current time.</P> Thu, 24 Oct 2019 16:53:32 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-Query-help-to-find-time-difference/m-p/469276#M132061 NAVEEN_CTS 2019-10-24T16:53:32Z https://community.splunk.com/t5/Splunk-Search/Splunk-Query-help-to-find-time-difference/m-p/469277#M132062 <P>Doesn't this work for you?</P> <PRE><CODE>index=&lt;yourindex&gt; earliest=-30d latest=-7d | stats count(X) </CODE></PRE> Thu, 24 Oct 2019 18:25:53 GMT https://community.splunk.com/t5/Splunk-Search/Splunk-Query-help-to-find-time-difference/m-p/469277#M132062 tiagofbmm 2019-10-24T18:25:53Z