When I call the MONTH function on a date where the day is higher than 12, it works properly. But when I do it with a date where the day is less than or equal to 12, it returns the day value. So
MONTH(#23/03/2000#) returns 3 but
MONTH(#03/09/2000#) returns 3 as well
I double-checked the format of my dates as they are stored in the table, as well as how they are entered in the text-box before I click search on my form. It is the DD/MM/YYYY format.
The Query is "SELECT * FROM Employees WHERE MONTH(birthday) = MONTH(#21/05/2000#)"
I set this query as the record source of my form and it's being populated with the wrong results.