Mapping of two dates field

[renjithpl]

Hi All,

I have a table like below,

There are two date fields, Date Coded and QC Date,

Date Coded	QC Date	Emp. Code	QC Reviewer	Changes
30-Apr-12	1-May-12	247	Martin	1
30-Apr-12	1-May-12	247	Daniel	1
30-Apr-12	1-May-12	247	Martin	1
1-May-12	1-May-12	247	Martin	1
2-May-12	1-May-12	247	Martin	1
2-May-12	2-May-12	247	Daniel	1
3-May-12	2-May-12	247	Daniel	1

In my qvw, i have a list box of Date Coded, user will select a date from Date Coded, for eg. user selects 1-May-12, then it will find same date in QC Date and give the sum of changes. so my answer should be 5.

I cant use QC Date in my application

Regards

Renjith