Fetch records between two dates

[jmoses99]

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

[royUK]

Use AutoFilter

[jmoses99]

Hi ,


If I apply auto filter, the data of only one data is getting displayed.

I'm working on Xcelsius for which Excel is the data modeling tool. I bind the data in excel to the components in Xcelsius. I've two combo boxes; one for start date and another for finished date. Now, when I select 1/3/2008 as start date and 3/5/2008 as finished date, the data between these two dates should be captured. My question is : how to retrieve the data? Any function that is useful in this scenario?



Thanks
John