how to sysdate() in universe

[system]

There is a very nice FAQ entry about using sysdate for date objects.

120×120 10.4 KB

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…

You have already asked about the previous quarter in another topic; please do not start another discussion here, but use the original topic. Thanks.

120×120 10.4 KB

Hi, I have one field calld tran_date. Need to find previous quarter data.pls help me to write sql in Univere level have tried. Insert new object called Pre_qtr 2.In edit properties window i cant go ahead. ur help is much appriactaed. BONEW (BOB member since 2004-09-03)

Closing topic.

---

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