[Solved] Customizing date format in reports
Posted: Tue Jan 17, 2017 11:29 pm
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.
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.