Hi Kurt
Great.
To get a list of records in a specific date range, I would actually use MySQL instead of PHP; it's much more efficient.
Keep in mind that date functions can get rather advanced.
What I would start with is a simple "WHERE" in your "getRecords" like this:
// load records from 'news'
list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'loadUploads' => true,
'allowSearch' => false,
'where' => "start_time > '2017-01-03' AND end_time < '2017-01-15' "
));
See how I have the "where" setup there?
Make sure you change the field names so they match your setup. I highlighted my assumed field names in blue.
Let me know how you make out.
Thanks!
-----------------------------------------------------------
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/