How to subtract DateTime.date and date fields

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Project
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

How to subtract DateTime.date and date fields

odoo12

1 Vastaa

4729 Näkymät

jenan soliman

When I traying to subtract this :

def get_duration(self):
    for rec in self:
        if rec.notification:
            if rec.notification == 'month':
                rec.notification_date = self.date_end - fields.Date(date.today() + relativedelta(months=1))
                print(type(self.date_end))
                print(type(date.today() + relativedelta(months=1)))

I get this error unsupported operand type(s) for 'datetime.date' and 'Date'.

MUHSIN KOTTAKKUTH

Paras vastaus

Hi jenan soliman,

You are trying to subtract between different data types. you can use following code for finding today's date. So both the datatypes will be in same format (fields.Date()). When you subtract two date objects, you will get the difference of those dates only. it will be a datetime.timedelta() object not a date object . So you have to find the date again using this timedelta object . See the code snippet below.

date_today = fields.Date.today()
date_difference = self.date_end - (date_today + relativedelta(months=1))
rec.notification_date = self.date_end - relativedelta(days=date_difference)

Thanks

Happy to help,

jenan soliman

Tekijä

hi Muhsin,
I tried this, but I also get this error
'datetime.timedelta' object is not subscriptable.

MUHSIN KOTTAKKUTH

Hi @jenan,
Sorry, I have updated the Answer with more details. please check once again, and don't forget to upvote if you find the answer usefull.

Thanks in advance

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Odoo Mail Sending Limit Ratkaistu odoo12	2 jouluk. 23	14798
(Document type: Invoice, Operation: write) - (Records: [], User: 2) odoo12	0 lokak. 23	33
Error while importing data in Odoo12: An unknown issue occurred during import (possibly lost connection, data limit exceeded or memory limits exceeded) odoo12	3 lokak. 23	788
Remove duplicate record when importing data from excel to Odoo odoo12	1 lokak. 23	569
Multiple group on field Odoo12 odoo12	1 elok. 23	2520

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!