Hi all,


I've data something like below in excel sheet :


Start Date Finished Date Order Order Qty Unit Plan Cost Plant Unit

1/3/2008 1/3/2008 90009088 1 PC 7271.12 7271.12
1/3/2008 1/3/2008 90009089 1 PC 7271.12 7271.12
1/3/2008 1/3/2008 90009090 1 PC 7271.12 7271.12
1/3/2008 1/3/2008 90009091 1 PC 7271.12 7271.12
2/5/2008 2/5/2008 90009086 1 PC 7299.88 7299.88
3/5/2008 3/5/2008 90009090 1 PC 7271.12 7271.12

Now if I select 1/3/2008 at start date and 3/5/2008 as finished date, the records that fall between these dates should be captured. How to perform this ?


Thanks
John