Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
pythoncustomcompute
1 Odgovori
5122 Prikazi
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
Opusti
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
Opusti
Sam F
Avtor

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
Avtor

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
Avtor

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 Odgovori Prikazi Aktivnost
How to get a person's age from his date of birth in Odoo? Solved
python compute
Avatar
Avatar
Avatar
2
maj 20
6895
How can I do in compute method to differ two datetime ? Solved
python compute odoo
Avatar
Avatar
1
jan. 17
5921
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
1282
compute field not working properly
python model compute technical
Avatar
Avatar
Avatar
2
jun. 23
5298
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
24458