I'm trying to retrieve some calendar entries. With the following code I get always all entries with category id 12. The date is not used.
What would be the right syntax ?
dt = datetime.now()
args = [('categ_id','=',12),('date','=',str(dt))]
ids = sock.execute(dbname, uid, pwd, 'crm.meeting', 'search', args)
Update
Thanks so far but it won't:
Database:
test=# select * from crm_meeting where date='2013-03-25 00:00:00';
-[ RECORD 1 ]----------+---------------------------
id | 663
create_uid | 1
create_date | 2013-03-25 11:32:19.318743
end_type | forever
date | 2013-03-25 00:00:00
freq | None
categ_id | 17
class | public
Python:
dt = datetime.now().strftime("%Y-%m-%d 00:00:00")
print dt
args = [('categ_id','=',17),('date','=',dt)]
ids = sock.execute(dbname, uid, pwd, 'crm.meeting', 'search', args)
print ids
Output:
2013-03-25 00:00:00
[864, 863, 862, 861, 860, 859, 858, 857, 856, 855, ...
still getting all entries with categorie id 17 ...