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

相关帖文	回复	查看
How can I make information invisible or visible on a chart in spreadsheets \| Odoo 17 已解决 Documents Spreadsheets Quickstart SF-Experts Odoo17	1 8月 24	1284
How can I know how a report was created (where the data came from) in spreadsheets \| Odoo 17 已解决 Documents Spreadsheets Quickstart SF-Experts Odoo17	1 8月 24	1249
How to create a commission report for my sales team/people \| Odoo 17 已解决 Documents Spreadsheets Quickstart SF-Experts Odoo17	1 7月 24	1913
Can I use Odoo's Spreadsheets instead of Excel for my operations \| Odoo 17 已解决 spreadsheets Documents Quickstart SF-Experts Odoo17	1 7月 24	2153
Why do my Expenses lines have different colors \| Odoo 17 已解决 Expenses Quickstart Expense SF-Experts odoo17	1 7月 24	1481

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！