Hi,
I have two date fields "from_date" and "to_date" and if the current date is between or equal to "from_date" or" to_date" I want to get all such records from the model.
How could I search these records??
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- सीआरएम
- e-Commerce
- लेखांकन
- इन्वेंटरी
- PoS
- प्रोजेक्ट
- MRP
This question has been flagged
1
Reply
14474
Views
Hello Sebin,
Try this :-
search_obj = self.env['model.name'].search([('from_date', '>=', fields.date.today()), ('to_date', '<=', fields.date.today())])
Hope it works for you.
Thanks,
hi Jignesh Meha,
offers = self.env['offer.sales'].search([('branch_id', 'in', line.branch_id.ids),('from_date', '>=', line.date_order),('to_date', '>=', line.date_order)]) not getting data from offer.sales models
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
0
अक्तू॰ 23
|
3597 | ||
|
1
नव॰ 22
|
4361 | ||
|
4
दिस॰ 21
|
34859 | ||
|
0
जून 21
|
6877 | ||
|
0
मार्च 21
|
3748 |
