BusinessObjects Board

currentdate object in universe

Hello folks,

I want to create an object in the universe for ‘current date’ and I’m gonna use this to calculate difference between two dates.

The universe was built on SQL Server 2005 DB

I couldn’t find the right function, I’ve tried using GETDATE() for creating a new date obj at universe level but it dint help. I even used DATE() but when i parse it throws the following error.

Parse Failed: Excepetion: DBD, [Microsoft OLE DB provider for SQL Server]: Incorrect syntax near ‘From’. State: 42000

Can you please help me pointing where I’m going wrong.

Thanks

Ravee


ravi.bo :uk: (BOB member since 2009-09-01)

Covered in the FAQ


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

Thanks Dave.

It helped.

Ravee


ravi.bo :uk: (BOB member since 2009-09-01)