How to retrieve users from a database for a specific date?

Question

PHP

There is a database, n number of users are added to it every day, each has its own date of the form: 01/01/2016 | 00:41:06
How to remove users from the database only on a certain date? for example, display how many users with the date 01/31/2015 using php
-------------------------------------- -------
$Result = mysqli_query($CONNECT, 'SELECT * FROM `users` WHERE field `date` = "31.01.2015%"');
so tried

Answer 1

If the date is stored as text, then you can do this.
If the field is as DateTime, then
where date(field) = '31.01.2015'