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 _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
