Query custom post types by two custom date fields

Sorry about the long delay in replying. I had totally forgotten about your question. So to maybe help guide you through what i did here are some tips.

First thing i did was i made page called Events Widget (you can call it whatever you want.) I made a blank WordPress Template and removed the header and footer functions because the query inside of the page is just going to output a list of events and I’ll load it in later with ajax. I have a default query where i build the start date as being “today” and then the end date is this month, this year, and the last day of this month. That’s the way I get all of events that happen in this month.

Then i applied the function we spoke about above to modify the query and output all of the events in the query that fit in the date range.

Later I modified this same page by allowing the query strings to define the startday and endday. If _m and _y are defined then they are processed and the start day and end day are created based on the query string. So that’s how i am changing the query.

Then on the homepage I have an area where i am loading the events and i display them by month / year. There are two arrows to flip through the events by month.

Here is all of that code:

<?php
global $post;
if (isset($_GET['_m'])) {
	$current_month = date('m', $_GET['_m']);
	$current_year = $_GET['_y'];
} else {
	$current_month = date('m'); // This gets the current month
	$current_year = date('Y');
}
?>
<script language="javascript">var mnth=<?php echo $current_month; ?>;var yr=<?php echo $current_year; ?>;</script>
<p><strong><a id="events-nav-prev" href="#prev"><<</a> | <a id="events-nav-next" href="#next">>></a></strong> <span class="date-info"></span></p>
<img src="<?php bloginfo('template_url'); ?>/images/loading.gif" alt="Loading..." id="upcoming-events-loader" style="visibility:hidden;" />
</div>

<div id="upcoming-events-scroller" class="scrollable">
<script language="javascript" type="text/javascript">
/* use a function for the exact format desired... */
var d = new Date();
var m_names = new Array("January", "February", "March","April", "May", "June", "July", "August", "September", "October", "November", "December");

function getEvents(getAll) {
	jQuery('#upcoming-events-loader').css('visibility', 'visible');
	jQuery('#upcoming-events-months .date-info').html(m_names[mnth-1] + " " + yr);
	jQuery.get('/events-widget/', {
			_m:mnth,
			_y:yr,
			getAll:getAll
		}, function(data) {
			jQuery('#upcoming-events-scroller').html(data);
			jQuery('#upcoming-events-loader').css('visibility', 'hidden');
		});
	}

jQuery(document).ready(function() {
	getEvents('true');

	// bind nav events
	jQuery('#events-nav-prev').click(function() {
		if (mnth == 1) {
			mnth = 12;
			yr -= 1;
		} else {
				mnth -= 1;
		}
		console.log(mnth);

	jQuery('#upcoming-events-months .date-info').html(m_names[mnth-1] + " " + yr);
			getEvents();
			return false;
		});

	jQuery('#events-nav-next').click(function() {
			if (mnth == 12) {
				mnth = 1;
				yr += 1;
			} else {
				mnth += 1;
			}
			console.log(mnth);

	jQuery('#upcoming-events-months .date-info').html(m_names[mnth+1] + " " + yr);
			getEvents();
			return false;
	});
});
</script>

just deployed it to my development website and no issues to report, it still works! handy plugin. I was originally hoping to be able to do this query without a plugin, but your plugin is light enough that i think its a good solution. Awesome to be able to replace a whole Events Calendar plugin with this one light plugin. I do wish the ACF date picker fields would be able to work this way out of the box.

Anyway, thanks for your excellent assistance. Great plugin!