Getdate

building semantic layer
1

Hi,

Application : BO XI 4.0
Database: SQL Server 2008

Created Object called Current Date in the universe, I have assigned value as Getdate() , when I parse, I am getting error saying

Parse Failed:Exception:DBD,[Microsoft SQL Server Native Clien 10.0]: Incorrect Syntax near ‘From’,State"42000

And then I tried the below inbuilt function as well, getting the same error

convert (SMALLDATETIME, {fn CURDATE()})

Is there anyway that I can get Todays date in the universe.

Thanks

Gracelin (BOB member since 2010-04-29)

2

Hi,

Even though the object does not parse (because it does not reference a real table) it should work in a query when it’s used with any other normal universe object. Try it.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thanks a lot ,Marek… Its working…

Gracelin (BOB member since 2010-04-29)

4

For what it’s worth, this is covered in the Designer FAQ topic…

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