How do you convert a date field to a string?

Question

Not really sure if its a string already but I'm trying to get the number of the week like this

>>> from datetime import datetime
>>> nweek = datetime.strptime(date_invoice,'%d/%m/%Y').isocalendar()[1]
and the result in odoo is 0, so I'm guessing its because the field "date_invoice" is a field type "date" and this strptime command works with strings, am I doing something wrong?

thanks

Dipak Shah · Accepted Answer

Hey Luis Fuentes,

Simply just check with below code :

> type(date_invoice)

1) if its like <type 'str'> then you have to convert it into date format using as below syntax.

> date_inv_dt = datetime.strptime(date_invoice,'%d/%m/%Y')

.....and then for getting week no as below.

date_inv_dt..isocalendar()[1]

2) if its like <type 'datetime.datetime'> then you do not need to convert to date format ,then you can go ahead to get week no. like,

> nweek = date_invoice.isocalendar()[1]

Thanks.

MYAT THU · Answer

nweek = datetime.strptime(str(date_invoice),'%d/%m/%Y').isocalendar()[1]

Bienvenido Villabroza · Answer

If you're using Python 3 or Odoo 13, the following code works: date_field.strftime("%U"). You can replace "%U" with a bunch of other things to format the date object properly: https://www.w3schools.com/python/python_datetime.asp

Palkesh Baraiya · Answer

Hey Luis Fuentes,
May be this will Help You,
Using this You can find Day, Month, Year, Week, DayofWeek.
from datetime import datetime, timedelta
date_doen = datetime.date.today()
do_date = datetime.strptime(date_done, "%Y-%m-%d %H:%M:%S" )
day = do_date.day
month = str (do_date.month)
year, week, dayofweek = do_date.isocalendar()

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!