'where'       => "start_date < NOW() AND end_date > NOW() "

Instead you want

'where'       => "start_date <= NOW() AND end_date >= NOW() "

Thank You!!  That is exactly what I needed.  The CURDATE() worked perfectly for me.

'where'       => "start_date < NOW() AND end_date > NOW() "

Selects any promotion where the start_date is before now AND where end_date is after NOW

You may find that CURDATE() is a better fit than NOW(). NOW() is very specific down to the second. CURDATE() is only concerned with the date itself. 

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!

More specifically show me all of the records whose start date is <= to today’s date and whose end date is > today.

These are promotions and I need them to display if they are valid today

Thanks for posting.

I'd like to clarify what you are looking for.

What I get from you post is that you want to display a list of records whose start and end dates fall within a specific range.

So you need a way to say, show me all records between January 1 and February 23.

Am I on the right track?

Thanks!

Start Date: <?php echo date("D, M jS, Y g:i:s a", strtotime($record['start_date'])) ?>
End Date: <?php echo date("D, M jS, Y g:i:s a", strtotime($record['end_date'])) ?>