Filtering the Last Month & Last Month Previous Year

[system]

Hi All ,

I have to use the filter in Webi , formulate to filter Last month to Previous Year last month date range.

How can I use it with the existing system date range.

---

vpsenit (BOB member since 2014-08-01)

[system]

Welcome to B:bob:B!

What database do you use?

---

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

[system]

Hi Marek ,

Thanks for responding , Its MySql.

---

vpsenit (BOB member since 2014-08-01)

[system]

Hi,

Try if this sticky topic will help:

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)