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)
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 (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 (BOB member since 2005-03-01)
Thank you Michael, Thank you Debbie.
Regards,
Judia
judia (BOB member since 2008-06-24)