date create/modify in advance search is not working

[rus]

Hi,
I added the Date Create and Date Modified to advance search.
but the search is not working, it always return nothing.
Is there something I missing ?

I use sugarcrmCE 5.0.0h with SQL Server 2005 and Windows Server 2003.

regards,
rusdi

[sugarcane]

Hi rusdi,

there is a bug in the system. If you set your user settings to display date fields in the 'yyyy-mm-dd' format, then your search will work. If you have your date displayed in any other format, it will not work.

[rus]

oic, thanks for your information.

btw I tried set the date like you said at the "My Account" and the "Local Setting" (admin) page but it seems the search is still not working. Is there any other setting that I should change?