Skip to Content
avatar image
Former Member

Busines Objects Universe 3.1 SP7 CurrentDate function

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 29, 2017 at 08:28 PM

    Hi Gurvinderpal,

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

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 19, 2017 at 02:15 PM

    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

    Add comment
    10|10000 characters needed characters exceeded