How to Convert Serial Date Number to Date in BusinessObjects

Updated March 23, 2017

BusinessObjects is a leading business intelligence tool used to query data from the database. The data is presented in a simplified format allowing end users to create reports and analyse the information to make business decisions. Dates are selected using classes and objects found within hierarchies that are used to obtain further details. Detailed transactions containing dates for vendor invoices, sales orders and purchase orders can be obtained and formatted according to the user's specifications.

Highlight the cell, row or column that contains the number that needs to be formatted. Open the cell format dialogue box by right-clicking, or by clicking "Cell" from the format menu in the toolbar. Several cell formatting tabs will appear, including number, alignment, font and shading tabs.

Select the "Number" tab. Several number categories will appear, including standard, custom and number. Highlight the date/time category and a list of date formats will appear in a list in the right box. Select the date format you wish to use for your report and press "OK." The new date format is now applied to your report. Save your changes.

Customise your date based on a standard format found in the date/time category in the cell format dialogue box or by creating a formula within a variable using the variable editor if you wish.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Keela Helstrom began writing in 2010. She is a Certified Public Accountant with over 10 years of accounting and finance experience. Though working as a consultant, most of her career has been spent in corporate finance. Helstrom attended Southern Illinois University at Carbondale and has her Bachelor of Science in accounting.