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!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: