Skip to Content
This question has been flagged
11 Replies
56007 Views
Avatar
Damian Galinski

Hi,

All fields with date (Order date, Scheduled date etc) are in format datetime. Can I change it to just date?

Here is screenshot:

https://www.dropbox.com/s/x8ps66k3xymhdn0/Screenshot 2016-11-14 11.44.57.png

Thanks,

Damian

Avatar
Discard
Ray Carnes

Thanks for reply.

Do I need to change it in the code or somewhere in settings?



Sehrish

datetime.datetime.strptime(self.expiry_date, '%Y-%m-%d').date()

Avatar
Abhay Rathore
Best Answer

If you only need change format of  Datetime to Date in view. You can use this code.
 

1 . For forms or tree view use widget ''date"

 <field name="date_from" string="Date" widget="date"/>

2 . For reports or qweb use

for t-esc              ->  <span t-esc="o.date_from" t-options='{"widget": "date"}'/>
for t-fields -> <span t-field="o.date_from" t-field-options='{"format": "dd-MM-yyyy"}'/>
Avatar
Discard
Avatar
Janeesh
Best Answer 
Change
date_order = fields.Datetime('Date')
to
date_order = fields.Date('Date')
Avatar
Discard
Amin

This is good solution, however, it requires changing the python code.

Avatar
Ray Carnes
Best Answer

With Developer Mode active:

1. Settings --> Translations --> Languages.

2. Click on English (or the language you use).

3. Set Time Format to a space (it can't be blank).

Refresh the browser page or log out and back in.  In the screens and reports I tried after making this change, it worked fine - no times showed up where Datetimes were previously shown.   I didn't test exhaustively.

Avatar
Discard
Avatar
Shameem Babu
Best Answer

Damian,

You redefine to Datefield from Datetimefield

# Before
date_field = fields.Datetime('Date')


# After
date_field = fields.Date('Date')


Avatar
Discard
Keyur

Shameem, by doing this what will happen to past data?

Shameem Babu

Sorry I don't know the past data is converted or ignored

Janeesh

When changing a field type, existing data will be cleared

Avatar
Amin
Best Answer 
This worked well. Thank you @Abhay !

<span t-esc="o.date_from" t-options='{"widget": "date"}'/>
Avatar
Discard
Avatar
Tien Nguyen
Best Answer

If you only need change format of Date or Datetime in view. You can use this code.

for report
<span t-field="o.date" widget="date" 
    t-field-options="{'format': 'dd/MM/yyyy'}"/>
OR for view
<field name="o.date" widget="date" options="{'format': 'dd/MM/yyyy'}"/>

format: 'dd/MM/yyyy' will help you.

Thanks

Avatar
Discard
Avatar
ITStore
Best Answer

https://apps.odoo.com/apps/modules/13.0/user_wise_datetime_format/

Avatar
Discard