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