Busines Objects Universe 3.1 SP7 CurrentDate function

[Former Member]

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.

[Former Member]

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

[mhmohammed]

Hi Gurvinderpal,

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

Thanks,
Mahboob Mohammed