Getdate

system · February 21, 2012, 9:11pm

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)

system · February 21, 2012, 9:14pm

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 (BOB member since 2003-11-27)

system · February 21, 2012, 9:36pm

Thanks a lot ,Marek… Its working…

Gracelin (BOB member since 2010-04-29)

system · February 22, 2012, 7:35pm

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

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