How to Convert Serial Date Number to Date in BusinessObjects

Written by keela helstrom | 13/05/2017
How to Convert Serial Date Number to Date in BusinessObjects
Formatting the date in BusinessObjects is simple. (business report image by Christopher Hall from

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.

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.