Predefined Object in universe

[system]

Hi All

I have created a object(predefined In Universe) called last week and given the below syntax and its bringing the last 7days data.

months_between(@Select(System_W\Date), sysdate) between -0.25 and 0

now i want to create predefined conditions in the universe for Last Monday,Last Tuesday to sunday Like that.

can anyone let me know the syntax inorder to get this done.

Thanks,
Kumar.

---

kumarpjp (BOB member since 2009-04-13)

[system]

Hi,

This sticky topic can give you a good start:

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server. Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8. Yesterday cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime) Today cast(convert(char(10),getdate(),23) as datetime) The following also works for today: dateadd(dd, datediff(dd,0,getdate()), 0) Start of Current Month cast(convert(char(7),getdate(),23)+'-01' as datetime) End of Current Month dateadd(d,-1…

---

Marek Chladny (BOB member since 2003-11-27)