Calculating the value.

[#1]

Hi,

I have a input file which is having two date fields,I want to know how to get the quarter if date is blank and also want to do quarter wise calculation

Input Data is like this

Start Date	End Date	Value
11/10/2013	Blank	10
1/1/2014	2/4/2014	20

Output Should be Quarter wise Data for Start Date when End Date is blank

Output Should be

Start Date Year	2013
Start Quarter	Q4
Value	10

Want to do the Quarter wise sum based on two dates.

Input File:

Start Date	End Date	Value
11/10/2013	Blank	10
1/1/2014	2/4/2014	20
11/10/2013	1/1/2014	10

Output should be

Year	2013	2014
Quarter	Q4	Q1
Value	20	30

Please help me in solving this scenario.