Hi,
I want to create a date object in the Universe which will be the last day of last month. I can do this in SQL the following way…
last_day(add_months(sysdate,-1))
from dual
How can I accomplish this in BO? Table Dual is not available in the Universe. Is there another way around this?
Thanks!
mutsy (BOB member since 2007-11-27)
Hi,
Create your date object with this definition
last_day(add_months(sysdate,-1)) The object will not parse because it does not reference any table. However, it could be used with any other normal object(s) in one query and it will work just fine.
Give it a try and you will see 
Marek Chladny 
(BOB member since 2003-11-27)
This idea (using sysdate) is covered in one of our Designer FAQ entires too. 
Dave Rathbun 
(BOB member since 2002-06-06)
tip: you can use derived tables to ‘make’ any dual table
just type
select … as unique name,1
… as unique name2
etc
from dual
into sql code and presto, dual is present for you to use
IngeH 
(BOB member since 2004-06-22)