topic Re: Is there way to generate list of date for given month in Splunk in Splunk Search https://community.splunk.com/t5/Splunk-Search/Is-there-way-to-generate-list-of-date-for-given-month-in-Splunk/m-p/289919#M165760 <P>In what format you'd input the month, with year?</P> Fri, 06 Oct 2017 18:07:54 GMT somesoni2 2017-10-06T18:07:54Z Is there way to generate list of date for given month in Splunk https://community.splunk.com/t5/Splunk-Search/Is-there-way-to-generate-list-of-date-for-given-month-in-Splunk/m-p/289918#M165759 <P>Is there way to generate list of date for given month in Splunk </P> Fri, 06 Oct 2017 17:43:11 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-way-to-generate-list-of-date-for-given-month-in-Splunk/m-p/289918#M165759 asanka 2017-10-06T17:43:11Z Re: Is there way to generate list of date for given month in Splunk https://community.splunk.com/t5/Splunk-Search/Is-there-way-to-generate-list-of-date-for-given-month-in-Splunk/m-p/289919#M165760 <P>In what format you'd input the month, with year?</P> Fri, 06 Oct 2017 18:07:54 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-way-to-generate-list-of-date-for-given-month-in-Splunk/m-p/289919#M165760 somesoni2 2017-10-06T18:07:54Z Re: Is there way to generate list of date for given month in Splunk https://community.splunk.com/t5/Splunk-Search/Is-there-way-to-generate-list-of-date-for-given-month-in-Splunk/m-p/289920#M165761 <P>It really depends on what you're asking. This is a fairly vague question.</P> <P>If you're looking for a list of all dates between a month chosen in a date picker, for instance, something like this would work:</P> <PRE><CODE>|gentimes start=-1|addinfo|eval date=strftime(mvrange(info_min_time,info_max_time,"1d"),"%F")|mvexpand date|table date </CODE></PRE> <P>something similar could be applied if you're looking for dates reporting in a set of data. To really help, it'd be great if you could offer more details, thanks <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 06 Oct 2017 19:16:33 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-way-to-generate-list-of-date-for-given-month-in-Splunk/m-p/289920#M165761 cmerriman 2017-10-06T19:16:33Z Re: Is there way to generate list of date for given month in Splunk https://community.splunk.com/t5/Splunk-Search/Is-there-way-to-generate-list-of-date-for-given-month-in-Splunk/m-p/289921#M165762 <P>This is perfectly work for me. Thanks @cmerriman </P> Tue, 10 Oct 2017 18:52:52 GMT https://community.splunk.com/t5/Splunk-Search/Is-there-way-to-generate-list-of-date-for-given-month-in-Splunk/m-p/289921#M165762 asanka 2017-10-10T18:52:52Z