How to use between date query?
The raw SQL would be something like this,

SELECT startDate, endDate
FROM YourTable
WHERE GETDATE() between startDate and endDate;


You might could do like this with db_select

$query = db_select('node', 'n');
$query-&gt;condition(now(), array(node__field_start_date, node__field_end_date), 'BETWEEN');


I hope it helps