Create a key in your table load using
Recno() as RecID,
//Then create a LinkTable:
CROSSTABLE (DateField, Date)
LOAD RecID, Date1,Date2,Date3,Date4 RESIDENT Table1;
Now you can select your range from Date field or link this field to a master calendar.
What would be the performance of the application when it will go live. I have 47,000 rows an excel file. I have 8 attributes which are date type. So technically Cross Table will convert is as 47000*8 rows. Will this impact a performance? If yes what would be a best approach to tackle this?