system
June 3, 2013, 9:31am
#1
Hi,
I have a field (Submit Date) where in I need to create/automate a report which displays the previous months and current months data using the same field.
Please help me in creating the same condition in Universe level.
BO Version :XIR3.1 SP2
DB :Oracle 11g
Thanks
unknownanalytics (BOB member since 2011-07-18)
system
June 3, 2013, 1:10pm
#2
Hi,
This sticky topic will help you:
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)