HOW TO INSERT PREVIOUS YEAR IN LIST OF VALUES

[MarkP]

@dipa

I am able to insert *previous year in list of values of year object as ALL .
But I am not able to write code of condition to select previous year,ALL,year
so that I can drag it in condition pan of report.Plz tell me how to do it.
Thanks in advance.

Use this topic to create relative date objects

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…

Then in your data query, build a condition:
Transaction Date between Start of Previous Year and End of Previous Year

Or if you want it to be used in many reports, create it as a predefined condition.