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

[system]

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 (BOB member since 2010-04-08)

[system]

Hi, Welcome to B:bob:B! Our Designer FAQ has some information on that here:

FAQ: Designer

How can I use the current system date in an object? You use a different function for each database. For example, Oracle users would typically use sysdate while Sybase or SQL Server users would use getdate(). Teradata uses DATE, and DB2 uses CURRENT_DATE. Ask your DBA if you are unsure which method is appropriate for you. Ok, so I have done that, but my object does not parse. How can I fix it? These functions or pseudo-columns do not need to reference a table. Yet when De…

---

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

[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