[Solved] Current year function for a report header

Getting your data onto paper - or the web - Discussing the reports features of Base

[Solved] Current year function for a report header

Postby rabogardus » Tue Feb 16, 2016 12:14 am

Is there a function or combination of functions that returns just the current 4 digit year?
Last edited by Hagar Delest on Wed Feb 17, 2016 10:50 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice version 4.0.1
Operating system Windows 7
rabogardus
 
Posts: 10
Joined: Sat Oct 17, 2015 10:46 pm

Re: Current year function for a report header.

Postby acknak » Tue Feb 16, 2016 12:52 am

Insert > Fields > Date

Double-click on the inserted date field and change the display number format to show only the year.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Current year function for a report header.

Postby rabogardus » Tue Feb 16, 2016 1:27 am

We must be using different versions of the report editor because mine does not give me those options. Mine does not give me a Field option, only "Page Numbers", "Date and Time", "Report Controls", "Pictures" and "Shapes". When I select "Date and Time" I have the option of either Date or Time and a number of formats but none of them are just the year, either 2 digit or 4. That is where I got the Today() function, I selected the mmm dd, yyy format as the best alternative, but I would still like just the year.
OpenOffice version 4.0.1
Operating system Windows 7
rabogardus
 
Posts: 10
Joined: Sat Oct 17, 2015 10:46 pm

Re: Current year function for a report header.

Postby rabogardus » Tue Feb 16, 2016 1:36 am

Never mind, I got it. It was in the date fields Properties pane, General tab under Formatting. I had to go in and define my own format to display just the year. Thanks anyway and sorry to have taken up your time.
OpenOffice version 4.0.1
Operating system Windows 7
rabogardus
 
Posts: 10
Joined: Sat Oct 17, 2015 10:46 pm

Solved Re: Current year function for a report header.

Postby rabogardus » Tue Feb 16, 2016 1:38 am

Never mind, I got it. It was in the date fields Properties pane, General tab under Formatting. I had to go in and define my own format to display just the year. Thanks anyway and sorry to have taken up your time.
OpenOffice version 4.0.1
Operating system Windows 7
rabogardus
 
Posts: 10
Joined: Sat Oct 17, 2015 10:46 pm


Return to Reporting

Who is online

Users browsing this forum: No registered users and 3 guests