Hi all,
I have to maintain two fiscal years of data in qvd(current year and previous year).fiscal year start at nov and at oct month.
suppose data in database is available from nov -2013 then data in qvd should from nov-13 to till date for two fiscal year. once two fiscal years completed( i.e nov-2013 to oct-2014,nov-2014 to oct-2015) then nov-2013 to oct-2014 data should be deleted and it should store data of nov-2014 to oct-2015 and data from current running year.
please suggest solution
Thanks in advance....