Date

[system]

Hi,
Can we bulid something like a prompt at query level or predfined prompt into webi to use a variable date ranges?
ForExample: If i want to run a webi report with ACtivity Date of yesterday. Can something be done at query level or a predefined prompt to add yesterday, last week or last month as an option for date fields inorder that somthing could be scheduled without having to update the date values?

Thanks,

---

BODEV2011 (BOB member since 2010-12-28)

[system]

BOdev2011,

These are created as predefined filters in the universe so that they are available for everyone and all reports. Usually it is subtraction from the sysdate that will give you the dates that you need.

Hope this helps,

---

Mitra Moini (BOB member since 2002-09-01)

[system]

Hi,

In addition to Mitra’s post, the information in this sticky topic can be helpful:

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)

[system]

Thank you. I am not very familiar with this. Can someone just provide a sample. Using db2.

Thanks,

---

BODEV2011 (BOB member since 2010-12-28)