# Editable datetime field in list/tree view

**URL:** https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015
**Category:** Developer
**Created:** [November 29, 2019, 5:37am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015 "2019-11-29T05:37:07Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![kakamble](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/kakamble/32/494_2.png) [@kakamble](https://discuss.tryton.org/u/kakamble)
#### Post date: [November 29, 2019, 5:37am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/1 "2019-11-29T05:37:07Z")

</div>

> [@DateTime field on list/tree view?](https://discuss.tryton.org/t/datetime-field-on-list-tree-view/1593/2):
>
> You can display datetime on a list but you must use two columns: one with widget=“date” and one with widget=“time”.

For a module, I have tried displaying datetime field in tree as follows:

```
<field name="date_time_journey" widget="date"/>
<field name="date_time_journey" widget="time"/>

```

I am able to render the list view, but I am unable to save, with the following error being displayed

```
ValueError: invalid type '<class 'datetime.date'>' for <class 'trytond.model.fields.date.DateTime'>

```

Please suggest a way to save successfully

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [November 29, 2019, 9:24am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/2 "2019-11-29T09:24:51Z")

</div>

Please provide the full traceback.

---

<div class="post-metadata">

### Author: ![kakamble](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/kakamble/32/494_2.png) [@kakamble](https://discuss.tryton.org/u/kakamble)
#### Post date: [November 29, 2019, 10:19am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/3 "2019-11-29T10:19:56Z")

</div>

> [@DateTime field on list/tree view?](https://discuss.tryton.org/t/datetime-field-on-list-tree-view/1593/4):
>
> Please provide the full traceback

```
Traceback (most recent call last):
File "/trytond-5.0.15-py3.6.egg/trytond/wsgi.py", line 73, in dispatch_request
return endpoint(request, **request.view_args)
File "/trytond-5.0.15-py3.6.egg/trytond/protocols/dispatcher.py", line 46, in rpc
request, database_name, *request.rpc_params)
File "/trytond-5.0.15-py3.6.egg/trytond/wsgi.py", line 44, in auth_required
return wrapped(*args, **kwargs)
File "/trytond-5.0.15-py3.6.egg/trytond/protocols/wrappers.py", line 122, in wrapper
return func(request, pool, *args, **kwargs)
File "/trytond-5.0.15-py3.6.egg/trytond/protocols/dispatcher.py", line 176, in _dispatch
result = rpc.result(meth(*c_args, **c_kwargs))
File "/trytond-5.0.15-py3.6.egg/trytond/model/modelsql.py", line 147, in wrapper
return func(cls, *args, **kwargs)
File "/trytond-5.0.15-py3.6.egg/trytond/model/modelsql.py", line 994, in write
field.set(cls, fname, *fargs)
File "/trytond-5.0.15-py3.6.egg/trytond/model/fields/one2many.py", line 245, in set
Target.write(*to_write)
File "/trytond-5.0.15-py3.6.egg/trytond/model/modelsql.py", line 147, in wrapper
return func(cls, *args, **kwargs)
File "/trytond-5.0.15-py3.6.egg/trytond/model/modelsql.py", line 994, in write
field.set(cls, fname, *fargs)
File "/trytond-5.0.15-py3.6.egg/trytond/model/fields/one2many.py", line 247, in set
Target.create(to_create)
File "/trytond-5.0.15-py3.6.egg/trytond/model/modelsql.py", line 147, in wrapper
return func(cls, *args, **kwargs)
File "/trytond-5.0.15-py3.6.egg/trytond/model/modelsql.py", line 587, in create
insert_values.append(field.sql_format(value))
File "/trytond-5.0.15-py3.6.egg/trytond/model/fields/date.py", line 87, in sql_format
% (type(value), type(self)))
ValueError: invalid type '<class 'datetime.date'>' for <class 'trytond.model.fields.date.DateTime'>

```

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [November 29, 2019, 11:25am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/4 "2019-11-29T11:25:04Z")

</div>

I can not reproduce. Which version of the client are you using?

---

<div class="post-metadata">

### Author: ![kakamble](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/kakamble/32/494_2.png) [@kakamble](https://discuss.tryton.org/u/kakamble)
#### Post date: [November 29, 2019, 11:35am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/5 "2019-11-29T11:35:07Z")

</div>

I am currently testing this on SAO

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [November 29, 2019, 12:00pm UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/6 "2019-11-29T12:00:04Z")

</div>

This does not tell us which version.

---

<div class="post-metadata">

### Author: ![kakamble](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/kakamble/32/494_2.png) [@kakamble](https://discuss.tryton.org/u/kakamble)
#### Post date: [November 29, 2019, 12:04pm UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/7 "2019-11-29T12:04:50Z")

</div>

My SAO is currently version 5.0

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [November 29, 2019, 12:16pm UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/8 "2019-11-29T12:16:50Z")

</div>

It is still not a full version number. It must contain 3 numbers.

---

<div class="post-metadata">

### Author: ![kakamble](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/kakamble/32/494_2.png) [@kakamble](https://discuss.tryton.org/u/kakamble)
#### Post date: [November 30, 2019, 5:11am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/9 "2019-11-30T05:11:22Z")

</div>

My SAO version is 5.0.8

---

<div class="post-metadata">

### Author: ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)
#### Post date: [November 30, 2019, 9:32am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/10 "2019-11-30T09:32:52Z")

</div>

Try first with the latest of the 5.0 series (now it is 5.0.17).

---

<div class="post-metadata">

### Author: ![kakamble](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/kakamble/32/494_2.png) [@kakamble](https://discuss.tryton.org/u/kakamble)
#### Post date: [December 2, 2019, 6:18am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/11 "2019-12-02T06:18:56Z")

</div>

> [@ced](#):
>
> Try first with the latest of the 5.0 series

Working perfectly with 5.0.17. Thank you!

---

<div class="post-metadata">

### Author: ![system](https://discuss-cdn.tryton.org/uploads/default/original/1X/c6f8ec0a40525cdcd50058c734283450a4b3d38b.png) [@system](https://discuss.tryton.org/u/system)
#### Post date: [January 1, 2020, 6:18am UTC](https://discuss.tryton.org/t/editable-datetime-field-in-list-tree-view/2015/12 "2020-01-01T06:18:57Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.