Skip to Content
This question has been flagged
pythoncustomcompute
1 Reply
5188 Views
Avatar
Sam F

i have 2 fields, one we will pick a date, i would like the other to automatically compute -5 weeks from the selected date. i have played with the compute field in studio but have had no luck getting anything to work.

so far i have:


for record in self:

  record[("x_studio_field_CgBpj")] = record.x_studio_field_47ZJc - datetime.timedelta(weeks=+5)

Avatar
Discard
Avatar
DHA Medic
Best Answer

Odoo 11, Python 3.5

from datetime import datetime, timedelta
from odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT

class Test(models.Model):
    _name = "dhac.rad.project"

    test1 = fields.Datetime(string="Date Time A")
    test2 = fields.Datetime(string="Date Time B", compute="dp_test1")

    @api.depends('test1')
    def dp_test1(self):
        if self.test1:
            raw = datetime.strptime(self.test1, DEFAULT_SERVER_DATETIME_FORMAT)  - timedelta(weeks=5)
            self.test2 = str(raw)
Avatar
Discard
Sam F
Author

which parts of this will i need to change for my custom fields?

DHA Medic

You should share the code you are currently editing.

Thanks

Sam F
Author

i have, its in the original post.

im using the compute field in the studio.

DHA Medic

from datetime import datetime, timedelta

from odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT

for record in self:

record[("x_studio_field_CgBpj")] = datetime.strptime(record.x_studio_field_47ZJc, DEFAULT_SERVER_DATETIME_FORMAT) - timedelta(weeks=5)

DHA Medic

Try it bro, i don't test it

[tab]record[("x_studio_field_CgBpj")] = datetime.strptime(record.x_studio_field_47ZJc, DEFAULT_SERVER_DATETIME_FORMAT) - timedelta(weeks=5)

DHA Medic

My code: pastebin.com/yYTL4E5h

Sam F
Author

getting the error:

File "/odoo/odoo-server/odoo/tools/safe_eval.py", line 189, in assert_valid_codeobj

raise ValueError("forbidden opcode(s) in %r: %s" % (expr, ', '.join(opname[x] for x in codes)))

ValueError: forbidden opcode(s) in 'from datetime import datetime, timedelta\r\nfrom odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT\r\nfor record in self:\r\n record[("x_studio_field_CgBpj")] = datetime.strptime(record.x_studio_field_47ZJc, DEFAULT_SERVER_DATETIME_FORMAT) - timedelta(weeks=5)': IMPORT_NAME, IMPORT_FROM

Gerardo Busch

Are both fields of the same type? (Datetime or Date). If not, you need to convert it. I tried something similar and this was the problem I had.

Related Posts Replies Views Activity
How to get a person's age from his date of birth in Odoo? Solved
python compute
Avatar
Avatar
Avatar
2
May 20
6940
How can I do in compute method to differ two datetime ? Solved
python compute odoo
Avatar
Avatar
1
Jan 17
5959
How do I configure Sales Tax so that it is based on product cost, not the selling price? Solved
python tax custom formula
Avatar
Avatar
1
Feb 25
1314
compute field not working properly
python model compute technical
Avatar
Avatar
Avatar
2
Jun 23
5340
How can I add custom fields that calculate a combination of other fields? Like Sales Margin as a percentage? Without a module. Solved
python fields custom v9
Avatar
Avatar
2
Apr 23
24483