please help on loading rolling periods of qvd

[Anonymous]

Hi friends,we are getting data in .text files from 3 sources

There is no date filled to do incremental load .Luckily we have Accounting period column in all .text files,Accounting period has dates in irregular formats, my basic requirement is to display only 12 months of data in app.let say 2014-nov current date need to display 2013-nov qvd data in app,can any one please suggest how to handle this situation and also help on to create qvd folder structure to load past 12 months of data in qvds in application

[MK_QSL]

Load * Inline

[

  Date

  01/01/2013

  13/11/2013

  12/11/2013

  01/11/2013

  14/11/2014

] Where Date >= AddYears(Today(),-1);

or

Load * Inline

[

  Date

  01/01/2013

  13/11/2013

  12/11/2013

  01/11/2013

  14/11/2014

] Where Date(MonthStart(Date),'YYYYMM') >= Date(MonthStart(AddYears(Today(),-1)),'YYYYMM');

[Anonymous]

Please any one help on the Rolling of 12 months data,

We have 3 sources each source need to  store 12 months of data in .qvd format.

Source A-->abc2014.qvd(12 months) let say it has jan-14 jan-15 data after 12 months a separate data has to load in separate qvd say abc2015.qvd

Source B-->def2014.qvd(12 months)

Source C-->ghi2014.qvd(12 months)

While using QVD in Final application it should display Today()-12 i.e.,past 12 months from present .

can any one suggest in detail how to do this process dynamic way to do whole process

Let say today i see data in Application -Nov-2014

Need to see NOV-2013 -Nov-2014 data