last three years data.01-Apr-2013

[prma7799]

Hi All,

In my current application there have data from 01-Apr-2008 from till date.

Now my data become big every day and it is impacting our application day by day.

Now I want take only limited data say from 01-Apr-2013 to till date.

I want my financial year from 01-apr-2013 and fiscal year for 2013,2014,2015,2016

PFA script for callendar.

[prma7799]

Anyone can give some idea on this?

[Siva_Sankar]

You either change the value of VarMindate or Varmaxdate according to your requirements. or limit the data in the transaction table or in the fact table.

Ex:

Load * from your table

where Fiscal Year >='2013'

and financial date>='01-APR-2013';

[jagan]

Hi,

Try like this

where TempDate>= YearStart(Today(), -2, 4)   -- This will give 1-Apr-2013

and TempDate<=MakeDate(Year(today()),1,1)

ORDER BY TempDate Asc;

Regards,
jagan.

[pratap6699]

Load * from your table

where Fiscal Year >='2013'