Skip to Content
0

Busines Objects Universe 3.1 SP7 CurrentDate function

Jun 29, 2017 at 08:19 PM

31

avatar image

Hi

I need to know how to create a CurrentDate() function in the Universe, but I am not seeing that function. The Universe pointing to SQL Server database.

Any help or insight is greatly appreciated

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mahboob Mohammed Jun 29, 2017 at 08:28 PM
0

Hi Gurvinderpal,

Create an object with getdate() in the select clause, it'll give you the current date.

Thanks,
Mahboob Mohammed

Share
10 |10000 characters needed characters left characters exceeded
Gurvinderpal Singh Jul 19, 2017 at 02:15 PM
0

Hi Mahboob,

Thank you for your response. I tried this getdate() function in the select statement, but it does not work. But I resolved this issue, after create a derived table and set up relationship with physical table.

Thank you

Share
10 |10000 characters needed characters left characters exceeded