Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
1 Odpovědět
1890 Zobrazení
Avatar
doug jenkins

I am using V14 and am trying to calculate the duration.   I am using the following formula but it keeps returning a value of 0


for record in self:

    dateDueString = str(record.x_studio_pickup)

    dateMonthString = str(record.x_studio_invoice_date)

    try:

      dateDue = datetime.datetime.strptime( dateDueString, '%Y-%m-%d' )

      dateMonth = datetime.datetime.strptime( dateDueString, '%Y-%m-%d' )

      timeDifference = dateMonth-dateDue

      record['x_studio_duration'] = timeDifference.days

    except:

      record['x_studio_duration']=100000



Can someone tell me the error in my formula? 

Avatar
Zrušit
Avatar
Jack Dane
Nejlepší odpověď

Hello Doug,

You are using the same "dateDueString" variable in both "dateDue" and "dateMonth". So you are using the same date to compare with which is why you are getting 0 as an output. 

If you change your code to:

      dateDue = datetime.datetime.strptime( dateDueString, '%Y-%m-%d' )

      dateMonth = datetime.datetime.strptime( dateMonthString, '%Y-%m-%d' )

It should work.

I hope this helps,

Thanks, 

Avatar
Zrušit