Custom date fields are not searched on properly

[swettling]

I have tested this in my environment AND in the sandbox.
Using the sandbox as an example:

1)  I create/add a custom field to a custom data set of type Date
2)  This custom field is associated with contributions for this example
3)  I call this field "Start Date" and set it to "Searchable" (search via range or just via the value does not matter)
4)  I add a contribution via either the back-end or through a contribution page and add some date into "Start Date"
5)  Start Date is stored properly in the database
6)  I go to SEARCH >> FIND CONTRIBUTIONS
7)  I leave everything default except for "Start Date"
  Because I have it configured to search for a range, I input the following dates:  09/01/2010  and 09/30/2010.  My contribution should fall within that range
9)  I click "Search"
10)  Nothing is pulled up and the system says:

No matches found for:
Start Date >= January 20th, 9 ...AND...
Start Date <= 20th, 9

It is misinterpreting the dates.  It thinks that 09/01/2010 is  January 20th of the year 9.  Somehow it is looking for YY/MM/DD or something like that when it should be looking for MM/DD/YYYY.

I can't find where to configure or check this in the system, but not being able to search for custom dates is making doing queries very difficult.

Any help would be appreciated.

[Donald Lobo]

can you please file an issue. we'll fix this for 3.2.3

thanx

lobo

[bixgomez]

I am also having this exact same issue.

I am trying to run an advanced search on my contacts, filtering on a DATE custom field, "expiration date".

The search I am doing is for all contacts where the date is greater than today, which is 9/1/2010.

When I do this, it returns some results, but they are in correct, as the returned search criteria reads:

"Expiration Date >= January 20th, 9"

You can view a screencast here:

http://screencast.com/t/MzQ5ZmIyM

[Dwiding]

Is this issue still open? I am experiencing the same issue on 3.3 Beta1.

Thanks!