Odoo Help


Need to split month and year from date fields?

on 8/13/15, 6:32 AM 4,058 views

Dear Friends,

How to split month and year from date field and fetch that result in char field.Please advice me guys to done this.

Lingier Peter
On 7/6/17, 9:47 AM

Can you also use this code in the GUI?


Vale Trood

--Vale Trood--

| 5 2 7
Tunis, France
--Vale Trood--

Vale Trood
On 8/13/15, 7:19 AM

Try this friend:

import time

import datetime

from datetime import date

from datetime import datetime, date, time

ref_id = False

y = False

m = False

state = False

d = datetime.now().strftime('%Y-%m-%d %H:%M:%S')

print d

d_ref = datetime.strptime("2011-01-11","%Y-%m-%d")

print d_ref

d_to = datetime.strptime("2012-01-31","%Y-%m-%d")

print d_to

if d_ref < d_to :

d_ref = d_to

y = d_to.year

m = d_to.month

day = d_to.day

print y

print m

print day

print d

print (str(y),str(m),str(01))

You can eliminate the day :)



Baiju KS

--Baiju KS--
| 5 5 8
Kochi, India
--Baiju KS--
ODOO technical

        I like learning new thing, especially technical thing. I am a quick learner, I can learn technical things very fast. I have good logical skill,  I have immense interest in programming.

e-mail id : baijuks@hotmail.com

Baiju KS
On 8/13/15, 7:07 AM


Try this script:-

date = datetime.strptime(date_field, DEFAULT_SERVER_DATE_FORMAT)
month = date.month
year = date.year

Hope this helps..




| 4 4 6
Hyderabad, India

On 8/13/15, 6:41 AM

Hi Vadivel,

From Date field you will get date as string,  first convert it to datetime object type using:
date = datetime.strptime([your string date], "%Y-%m-%d") 

then you can simply use datetime attributes to get month and year as:

" print date.month, print date.year......." 

To show it in another field you can use on_change() method of [your date] field.

Don't forgot to import datetime at top as;

"from datetime import datetime"

Hope it helps you !    

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 8/13/15, 6:32 AM
Seen: 4058 times
Last updated: 7/6/17, 9:47 AM