Page 1 of 1

[Solved] Customizing date format in reports

PostPosted: Tue Jan 17, 2017 11:29 pm
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.

Re: Customizing date format in reports

PostPosted: Wed Jan 18, 2017 12:03 am
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

SOLVED! Re: Customizing date format in reports

PostPosted: Wed Jan 18, 2017 4:19 pm
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.