BusinessObjects Board

Relative dates in universe 4.0 using sql server 2008

Hi All,
I am using Universe designer 4.0. I need to create relative dates in Universe. I am using sql server 2008. i.e (Today,Yesterday, etc)
Kindly share your views.

Thanks.

Kind Regards,
Judia


judia (BOB member since 2008-06-24)

Today = cast(convert(char(10),getdate(),23) as datetime)
Yesterday = cast(convert(char(10),getdate(),23) as datetime)-1


MichaelWelter :vatican_city: (BOB member since 2002-08-08)

Or have a look in the sticky at the top of this forum - lots more here. DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

Debbie


Debbie :uk: (BOB member since 2005-03-01)

Thank you Michael, Thank you Debbie.

Regards,
Judia


judia (BOB member since 2008-06-24)