I have a requirement like this. I need to generate a report which has 2 fields start date and maturity date. I have FileA which has a date field and has some values say 12/31/2012, 01/05/2013, 10/01/2013,25/01/2013 and so on. I need to generate a report which has a field start date and maturity date. Only for first record in the report, the start date is from FileB. The maturity date for first record in report is from FileA(12/31/2012). The second record'start date is (12/31/2012) and maturity date is the second date from fileA(01/05/2013). Third record's start date is 01/05/2013 and maturity date is 3rd date from FileA(10/01/2013) and so on. How can I achieve this?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!