Zum Inhalt springen
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Diese Frage wurde gekennzeichnet
4 Antworten
9139 Ansichten
Avatar
Prajith

Hi,

I have created some records in 'test.test' table, i have two fields

created_date = field.Date(string='Created date')

days_difference = fields.Integer(string='Aging' store=True, readonly=True)

i need to calculate the days difference (today-created_date) in a every day for each record in the list view


Please help me to calculate this

Avatar
Verwerfen
OdooBot
is this work every day


On Sat, Oct 5, 2019 at 12:57 PM Cybrosys Techno Solutions Pvt.Ltd <odoo@cybrosys.com> wrote:

A new answer on How to calculate the Days difference (created date - today) has been posted. Click here to access the post :

See post


Sent by Odoo S.A. using Odoo.

Avatar
Gokulakrishnan Murugesan
Beste Antwort

Hi Prajith try following code,

import datetime

created_date = fields.Date(string='Created date')

@api.model
def _compute_difference(self):
    for rec in self:
        converted_date = datetime.datetime.strptime(rec.created_date, '%Y-%m-%d').date()
        rec.days_difference = (datetime.date.today() - converted_date).days

days_difference = fields.Integer(string='Aging', store=True, compute=_compute_difference)
Thanks.
Avatar
Verwerfen
Avatar
Cybrosys Techno Solutions Pvt.Ltd
Beste Antwort 
days_difference = fields.Integer(compute='_compute_difference')
def _compute_difference(self):
    for rec in self:
        rec.days_difference = (date time.today()- rec.created_date).days            ​                ​              ​                ​

Hope this will help you


Avatar
Verwerfen
Melvin

Can you please elaborate more on this?, but for field computation not backend coding.

Vasilis Zartilas

This working for me:
* rec.days_difference = (datetime.today().date()- rec.created_date).days

Avatar
Achuthan
Beste Antwort

You can use this date difference.

[('date','<=', ((context_today()-datetime.timedelta(days=10)).strftime('%Y-%m-%d')))]


Avatar
Verwerfen
Avatar
Vasilis Zartilas
Beste Antwort 
created_day = fields.Date(default=fields.Date.context_today)
days_difference = fields.Integer(compute="_compute_difference", readonly=True)
@api.depends("created_day")
def _compute_difference(self):
    for rec in self:
        today = fields.Date.from_string(fields.Date.today())
        crt_day = fields.Date.from_string(rec.created_day)

        difference = (crt_day - today).days
        rec.days_difference = difference
Avatar
Verwerfen