c2c-oerpscenario team mailing list archive

["Ferdinand @ ChriCar" <655266@xxxxxxxxxxxxxxxxxx>]

I would suggest the following 
for the 
* current date-time use now()
* for all past date selected
* for from: use 00:00:00 for time
* for to use: 23:59:59

it's a constant source of (hard to explain) errors

other example - location-structure - selecting a date -
"from" takes selected date + current time - which has to be manually adjusted to 00:00:00
"to" takes selected date + current time - which has to be manually adjusted to 23:59:59

I just want to recall that filtering fields like "create_date"  this way might miss some data as the datetime is stored like 
 2010-10-09 23:59:59.330704
unlikely but true.

-- 
[trunk] datatime search widget looses data
https://bugs.launchpad.net/bugs/655266
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP OpenObject.

Status in OpenObject GTK Client: New

Bug description:
example 
stock - tracability - stock moves

select a to date - it copies date 00:00:00 into the search

as the date is a datetime it must copy 23:59:59  to include all move of this date

it's critical because there are some dates  with time 00:00:00 and some with specific time

try 10/07/2010