How to search date range?

[#1]

Hi All,

I have the following three fields: Year, Month, Date

I can use them to filter the data, but now I was wondering how to use search the range of the date, say I want to search 2010-10-01 to 2011-01-01,

how to achieve it? Any object supports it?

Thanks.

[#2]

Check out the postings on Slider/Calendar objects.

[#3]

But the date range is across two years, how to use calendar to handle it?

[#4]

use

LOAD Year,

     Month,

     Date,

     date#(Year&Month&Date,'YYYYMMDD') as newfieldname

FROM

[1.xls]

(biff, embedded labels, table is Sheet1$);

in the script.

create Calendar objects or list box.