I have a browse form one column of which contains a date. The table column in MySQL is declared as "date". There are occcasions when I search for a specific date and the results show many other non-matching dates as well. Specific dates, "2016-02-12", "2016-03-03 & "2016-03-10" for example, cause this error. What is going on? It doesn't make any difference if I set a format on the browse column or not.
Also, why do I always have to search on "YYYY-MM-DD" when the browse column is not in that format?
**Update - I have tried changing the database table to store date as varchar(10), but the problem still exists.
Neil.
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Date search on browse form
-
vario
- Posts: 148
- Joined: Mon Dec 05, 2011 12:23 pm
- Location: Newton Abbot, UK
- Has thanked: 1 time
- Been thanked: 1 time
Re: Date search on browse form
Steven,
I created a test form to provide a screen shot (sensitive data on production form) and in doing so solved the problem! I had a zero-length date field on the browse which I had forgotten about, and this was providing the extra matches...
This does leave the issue of why I have to search using YYYY-MM-DD, otherwise please feel free to delete this thread!
Neil.
I created a test form to provide a screen shot (sensitive data on production form) and in doing so solved the problem! I had a zero-length date field on the browse which I had forgotten about, and this was providing the extra matches...
This does leave the issue of why I have to search using YYYY-MM-DD, otherwise please feel free to delete this thread!
Neil.