Hi all,
I want to search accounts by date, so I insert in account's base search form the field date entered (date created) but when I perfom a research it finds 0 accounts.
In my locale settings I set date format: dd/mm/yyyy
The only way to make this search is to set my locale settings to yyyy-mm-dd, that is the same as the datetime format in mysql db.
Looking into include/SearchForm/Searchform.php I found a function that should convert db_time to app_time anda viceversa, but it seems not to work.
Please please please somebody tell me why this date search doesn't work and what can I do to make it work.
Thanks
Using:
Sugar 5.0.0e
Linux openSuse
PHP 5.2.5
MySQL 5.0.45
Apache 2.2.4
Mozilla FIrefox 2.14


LinkBack URL
About LinkBacks



Reply With Quote
Bookmarks