how to fetch limited data only

[prma7799]

Hi All,

I have one application in that i want only current and last year data.I am using qvd generated for my application.

How can i achieve it.

Thanks

[prma7799]

Hi Robert,

I tried above formula but not get correct data.

I want data from 01-Apr-2014 to till date.

Thanks

[MayilVahanan]

Hi

Then try like this

I want data from 01-Apr-2014 to till date.

WHERE DivTarDate>=MakeDate(Year(today())-1,4,1)

and DivTarDate <=Today();

Make sure, both date are in same format

[robert_mika]

I think Mayil nail down your question...

[prma7799]

Hi Mayil,

I am stuck with fetch limited data load for 01-Apr-2013 to till date.

My requirement is i have data from 2008 to today date data.

I have to enhance my application so that i need last three year data.

I want financial year for 2013-2014,2014-2015,2015-2016 and fiscal year 2013,2014,2015,2016

Please help me.

PFA for calendar script.

[robert_mika]

Try/:

WHERE DivTarDate>=MakeDate(Year(today())-2,1,1)

and DivTarDate <=MakeDate(Year(today())+1,3,31)