[Solved] Customizing date format in reports

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
brockman
Posts: 30
Joined: Mon Jan 04, 2016 7:20 pm

[Solved] Customizing date format in reports

Post by brockman »

Hello Open Office Guru's!

Current Situation:
I have a table that has a date in it along with some other info.
and when I look in the table the date is displayed correctly(xx/xx/xx).
I have a query that retrieves the date and some other info.
and when I run the query it displayes the date correctly(xx/xx/xx).
I have a report that displays the date and other info.
The report displays the date in a numerical format. So 11/25/16 is rendered as "42699".

Goal:
I would rather the report display "11/25/16". How can I accomplish this?

Thanks in advance!


ps. I cannot use sun/oracle report builder as it does not work for some strange reason and I don't want to redesign all my reports anyway.
Last edited by brockman on Wed Jan 18, 2017 4:20 pm, edited 1 time in total.
LibreOffice 3.5.7.2
Linux Mint Maya 3.2.0-23-generic (x86_64)
XFCE 4
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Customizing date format in reports

Post by Villeroy »

Open the report for editing.
RIght click the date cell and format the cell. Writer table cells work like Calc cells. Dates are formatted day numbers.
Day 42699 equals 25/11/2016
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
brockman
Posts: 30
Joined: Mon Jan 04, 2016 7:20 pm

SOLVED! Re: Customizing date format in reports

Post by brockman »

Totally solved it! Thanks Villeroy!

I couldn't right click though, I had to go to the menu: table - number format. I love the menu!

I have to remember that reports are writer documents. I'm pretty good with writer, I should have solved this myself.
LibreOffice 3.5.7.2
Linux Mint Maya 3.2.0-23-generic (x86_64)
XFCE 4
Post Reply