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.
[Solved] Customizing date format in reports
[Solved] Customizing date format in reports
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
Linux Mint Maya 3.2.0-23-generic (x86_64)
XFCE 4
Re: Customizing date format in reports
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
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
SOLVED! Re: Customizing date format in reports
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.
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
Linux Mint Maya 3.2.0-23-generic (x86_64)
XFCE 4