Skip to Content
This question has been flagged
2 Replies
9899 Views
Avatar
muhammed

Thanks in advance ..

def onchange_loan_id(self, cr, uid, ids, loan_id, context=None):
        if loan_id:
            name = self.pool.get('bank.new_loan').browse(cr, uid, loan_id, context)
            due_date_of_installment=datetime.datetime.strptime(name.loan_due_date, '%Y-%m-%d')
            total_installment=name.number_of_installment
            monthly_installment=name.installment_amount
            next_due_date= (due_date_of_installment+datetime.timedelta(1*365/12)+datetime.timedelta(days=1))
            return {'value':{'name':name.name.name,'due_date_of_installment':due_date_of_installment,'number_of_installment':total_installment,'installment_amount':monthly_installment,'next_installment_due_date':next_due_date}}

Out put is raise TypeError(repr(o) + " is not JSON serializable") TypeError: datetime.datetime(2014, 5, 22, 0, 0) is not JSON serializable Cannot return dates...please help

Avatar
Discard
Dhinesh

Hi, do u need the date with time in particular??

Avatar
Roc cheng
Best Answer

Hi, In my code:

_columns = {
        'date_end': fields.date('Date End', required=True),
                }
_defaults ={
        'date_end': str(datetime.datetime.now().date()),
    }

datetime.datetime.now().date() get the date tye,then str()

Avatar
Discard
Avatar
Dhinesh
Best Answer

Hi, Python 2.7 cannot handle dates

from datetime import datetime
import json

data = {
    'title': 'Hello World',
    'created_on': datetime(2013, 4, 23, 0, 0)
}
print json.dumps(data)

This would create error like TypeError: datetime.datetime(2013, 4, 23, 0, 0) is not JSON serializable

Now try this in custom function like

from datetime import datetime
import json

data = {
    'title': 'Hello World',
    'created_on': datetime(2013, 4, 23, 0, 0)
}

def date_handler(obj):
    return obj.isoformat() if hasattr(obj, 'isoformat') else obj

print json.dumps(data, default=date_handler)

Now the result will be {"created_on": "2013-04-23T00:00:00", "title": "Hello World"}

Avatar
Discard