Date Objects in the universe - It's a SQL Server DB

[MarkP]

@Ami

Hii,
I am trying to create few date objects in the universe. It’s a SQL Server database.

For the currentdate object, I have tried getdate() in the select clause which gives me 'Incorrect syntax near ‘From’ error. I have also tried to use some other formats as well as @variable, @select but I am having issues.

I am also trying to create getdate() - 7 and getdate() -30, and having the same problem

Can someone help me with this, please?

Ami,

First thing - getdate() will not parse because it does not reference a table. As soon as you query this object with a table-based object in Webi/Deski, it will work fine.

Secondly, getdate() gives the current system date AND time.

Have a read through this topic for information on relative dates in SQL Server.

Regards,
Mark