Hi,
Here's the sample Data:
| Creation Date | PDC Date | Customer Name | Amount | Status |
|---|
| 8/1/2012 | 8/7/2012 | Adrian Luke | 78,000 | Active |
| 8/2/2012 | 8/6/2012 | Jesiel Jacob | 64,768 | Active |
| 8/3/2012 | 8/5/2012 | Jesse McArthur | 89,899 | Active |
| 8/5/2012 | 9/1/2012 | Sharon Concepcion | 34,900 | Close |
| 8/6/2012 | 9/5/2012 | Martin Michael | 67,234 | Active |
Say, I choose data 8/5/2012. It should display, PDC Date greater than the chosen date and Creation date is equal or less than the chosen date.
Thanks,
Bill
