how to create Current date or sysdate objects in designer

system · December 11, 2007, 9:47am

Hi ,
i want to create current date object.that object have CURRENT_DATE or SYSDATE(i am using SQL Server DB ) .i am trying to create that object but its giving errror. this object, i have to use in the report level.
means clients will drage that object and use this filter , its will run the report using today date.(in report i want to see today date information only).
any one can u please how to create an object using current_date or sysdate in desingnet

ramireddy.g (BOB member since 2005-03-24)

system · December 11, 2007, 9:57am

In SQL Server it’s getdate().

Edit: When parsing objects that do not reference a table Universe Designer will always throw an error message at you. You should verify object by dragging it into a report (together with an object that does reference a table).

wahey (BOB member since 2007-05-31)

system · June 24, 2008, 8:55am

What you can do though to not get the parsing warning message is to fool designer…

case when 1=1 then getdate() else dbo.ANYTABLENAME.ANYCOLUMNNAME end

(-:

Darth Services (BOB member since 2007-11-20)

system · May 15, 2009, 2:06pm

Hello, sorry I have a problem me to on current date.
In my designer i want to make an object who receives just the current date. I tried with curdate and current_date() or with getdate() but it’s the same mistake: check the manual for the right syntax to use.
Could you help me?
thanks

ssg9377 (BOB member since 2009-05-04)

system · May 15, 2009, 2:16pm

First: what database are you using.
Second: see this FAQ entry.

Dave Rathbun (BOB member since 2002-06-06)