I have created a view from an entityform that I've set up in D7/views 3.8. There is a request date field in my entityform. The field type is date. i have set the format to be m/d/Y.
I added a date filter in the view that is not working. After typing in the date several times, I literally copied the date from the view results and pasted it into the filter box, to be sure there were no typos and the filter still returns no results.
So I put in 10/02/2014 and nothing is returned
Does anyone one know what could be happening here?
Update: Here is what I "think" I know. I changed the filter to "contains", [just for testing]. I then entered '10' quick apply, it returned all rows that had a 10, did the same for '01' and '2014', all return rows. So I assume, even though I change the date format m/d/Y, it is not that way in the db or the view, so my search for '10/01/2014' is not working because that exact string is not in the date field.
How can I confirm/check and then fix? My users need to search using m/d/Y format in the filter box.
Update2: so after thinking about the above update, I was able to successfully run a query using this format in the filter box '2014-10-01'. I went back to be sure I had added the m/d/Y format. It is there and is being pulled into my entityform correctly, so why is it not going to the db this way?
How can I fix?