Need data till before one Year

[rishikeshtiwari]

Hi Guys,

I have a requirement that I need to load data in QVD till before one year. I have a data set having data from Apr-2013 -Nov-2016.

But I need to load the data from Apr-2013 to Nov-2015 (till before one Year). I have attached an excel sheet. In this sheet yellow highlighted coloured data is not required in QVD. Please let me know how I can load this data in script.

Thanks in Advance

Rishi

[its_anandrjs]

Check the attached file for logic as well.

Regards

Anand

[its_anandrjs]

Thanks You are Welcome

Regards

Anand

[sunny_talwar]

Rishi -

I am glad that you finally got what you wanted, but I don't see any difference between the two where statements below

Where Date <= AddYears(Today(), -1);

Date <= AddMonths(Today(), -12);

They mean the exact same thing. In both cases you are going back one year. Just two different ways to say the same thing. I would be very curious to see a sample where the second one worked for you, but not the first one