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 (BOB member since 2009-09-01)