I've read through the various date search posts on the forum already... They all seem to relate to problems thathave been fixed in PHPRunner 3.1
The problem I am having is this...
In the database I have a table called 'events' and it has has 'event_start_date' and 'event_finish_date' fields...
I use the date picker to enter the dates in both fields...
I deselect 'event_finish_date' from advanced search but leave 'event_start_date' enabled... I am using drop down boxes to select the dates in advanced search...
Now what I want to is search for an event in say August 2007... So I select August and 2007 but leave the day blank... This however will return ALL the events regardless of their start dates will be returned... If I select a day as well, then the search seems to work correctly...
Is there a way to search for a date using only the month and / or the year? e.g. If I use the year only then it will return all events regardless of the day or month... If I use the month and year then it will retrun events for that month and year only...
Thanks in advance
Jason