date search widget behave different for GTK (big usability issue) and WEB client for datetime fields

[Ferdinand]

branch-server 1787
branch-addons 2331
web-client 2486
GTK 962

GTK - date widget allows to enter date
like from 20090401 - 20090430
and creates search for date time fields
form 20090401 000000 to 20090430 000000
all date times between 20090430 000000 and 20090430 235959 are not selected
the search returns only to date which matches 20090430 000000

this is definitively not a desired behavior and not what users expect and may lead to subsequent errors because of wrong selection

WEB - date widget allows to enter date but keeps the current time withour user intervention
so at the time of writing it would select
from 20090401 155035 to 20090430 155100
(not the difference in seconds/minutes)
so the user has to manually set the time to 000000 and 235959
to be sure.

BTW I do not know if 235959 is always "good enough" if the date is stored internally with higher precision

        create_date
----------------------------
 2009-05-05 15:36:09.090756

    date_planned from stock move
---------------------
 2009-04-30 08:45:11
 2009-04-30 08:45:11

[Ferdinand (office-chricar)]

BIG Troubles
stock location
"product by location" 20090401 - 20090430 does not report postings of the last day

[Ferdinand (office-chricar)]

BIG troubles timesheet
sign in/out of last day of month is not displayed/calculated

[Husen Daudi (husendaudi)]

Thanks Ferdinand,

Improved in trunk client by adding datetime widget in search panel.

[Ferdinand (office-chricar)]

pls can his be backported to branch 5.x