search for dates in database between 2 user selected dates

[beanymanuk]

I'm creating an AJAX search and I need to pull date/s from the database which fall between the 2 user selected dates

The database field is a datetime field.

and the user selected values are also in datetime format.

 

If someone can point me in the right direction that would be great

 

<ol>
<label for="closetime">Registered between:</label>
<input type="text" class="datetime-pick hasDatepicker" name="registereda" id="registereda"> -
<input type="text" class="datetime-pick hasDatepicker" name="registeredb" id="registeredb">
</ol>

[Pikachu2000]

BETWEEN . . . AND