https://community.splunk.com/t5/Getting-Data-In/Stamping-dates-onto-report-PDFs/m-p/23915#M3761 <P>I can't figure out a simple way to do this - but there is a way to show the date range of events that are covered by a search. Assume that your original search looked like this</P> <PRE><CODE>yoursearchstuffhere | stats count </CODE></PRE> <P>Add this to include the date range</P> <PRE><CODE>yoursearchstuffhere | stats earliest(_time) as From latest(_time) as To count as "Number of Transactions" | fieldformat From=strftime(From,"%x %X") | fieldformat To=strftime(To,"%x %X") </CODE></PRE> Sun, 05 Aug 2012 02:54:41 GMT lguinn2 2012-08-05T02:54:41Z https://community.splunk.com/t5/Getting-Data-In/Stamping-dates-onto-report-PDFs/m-p/23914#M3760 <P>Hello,<BR /> I'm reasonably new to Splunk. I've created a scheduled search which runs weekly and links to a report showing the number of transactions we made last week. I want to put the "from" and "to" dates of that week in the header of the report, so that it is clear which week the report relates to. All I can get at the moment is the day that the report is printed on. Can anyone help?</P> Thu, 02 Aug 2012 12:27:07 GMT https://community.splunk.com/t5/Getting-Data-In/Stamping-dates-onto-report-PDFs/m-p/23914#M3760 watsm10 2012-08-02T12:27:07Z https://community.splunk.com/t5/Getting-Data-In/Stamping-dates-onto-report-PDFs/m-p/23915#M3761 <P>I can't figure out a simple way to do this - but there is a way to show the date range of events that are covered by a search. Assume that your original search looked like this</P> <PRE><CODE>yoursearchstuffhere | stats count </CODE></PRE> <P>Add this to include the date range</P> <PRE><CODE>yoursearchstuffhere | stats earliest(_time) as From latest(_time) as To count as "Number of Transactions" | fieldformat From=strftime(From,"%x %X") | fieldformat To=strftime(To,"%x %X") </CODE></PRE> Sun, 05 Aug 2012 02:54:41 GMT https://community.splunk.com/t5/Getting-Data-In/Stamping-dates-onto-report-PDFs/m-p/23915#M3761 lguinn2 2012-08-05T02:54:41Z