How can I change the date format on my spreadsheet to quarters of a year | Odoo 17.4

Question

I would like to pull a report into spreadsheets but I would like to change the formatting to show quarters instead of the actual date.

Adam Fadah (adfa) · Answer

You can do that in Odoo 17.4 following these steps:
Create your report and insert it into a spreadsheet:  1 [1] 2 [2] 3 [3]

2. Highlight your date column => click on Format => click on more date formats:
4 [4]

3. From there you can select one of the quarter date formats:
5 [5]

[1] /web/image/52971615-552ee29c/1.png?access_token=0cee2250-8dc9-46d1-a7c6-1476af85688a
[2] /web/image/52971612-ec637286/2.png?access_token=338d02a8-4464-4386-a00f-485d53b77a27
[3] /web/image/52971614-ec5e4e4d/3.png?a

Related Posts	Replies	Views
How can I make information invisible or visible on a chart in spreadsheets \| Odoo 17 Solved Documents Spreadsheets Quickstart SF-Experts Odoo17	1 Aug 24	786
How can I know how a report was created (where the data came from) in spreadsheets \| Odoo 17 Solved Documents Spreadsheets Quickstart SF-Experts Odoo17	1 Aug 24	708
How to create a commission report for my sales team/people \| Odoo 17 Solved Documents Spreadsheets Quickstart SF-Experts Odoo17	1 Jul 24	1155
Can I use Odoo's Spreadsheets instead of Excel for my operations \| Odoo 17 Solved spreadsheets Documents Quickstart SF-Experts Odoo17	1 Jul 24	1335
Why do my Expenses lines have different colors \| Odoo 17 Solved Expenses Quickstart Expense SF-Experts odoo17	1 Jul 24	870

This question has been flagged

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