BusinessObjects Board

current date

building semantic layer
#1

how can we add current date object in universe?

ch.nagaraju (BOB member since 2007-07-08)

#2

You will need to specify the database and version you are using since this differs across databases.

For Oracle, you can create an object with “Sysdate” in the select part of it. It won’t parse, but will work when used with another object in the report.

A simple search on this forum would also have answered your question.

dessa :madagascar: (BOB member since 2004-01-29)

#3

and if you are using sql server 2000, include CurrentDate() function in the Select of the object

Binary :australia: (BOB member since 2006-09-27)

#4

Or you can search this forum.

https://bobj-board.org/t/15391

Astro :argentina: (BOB member since 2007-02-15)

#5

Added to Designer FAQ

Dave Rathbun :us: (BOB member since 2002-06-06)