Comment 2 for bug 802996

Hello,

for problem of Sale Order: The _columns of SO has redefined the field create_date with new type as "date" where as OpenERP has predefined fields:id, create_date, write_date, create_uid, write_uid which means that there is no need for the developer to redefine those fields in his/her model.... but if he does so then ORM will ignore this fields while creating the instance. So the new type here in SO will not be changed at DB level where as it will show its effect only at view level. So when a user searches with this field then he is actually doing a search on a datetime field which has time also stored in db and resulting in no results.

The solution is to change the type to "Datetime" in SO.

For general search on create_date/write_date:
The bug report for this part seems invalid as the value of this field in DB will be stored along with the timestamp. So for such fields the user needs to make a search using the between(< & >) operator instead of "=" operator.

@ community Team: can you please change the project and team to related addons project and team.

correct me if I am missing something !

Thanks !