filter question

[#1]

hi!

i'm working on this table and i want to create a filter where i can insert a start day, for example 9/5/14, and an end day ,for example 11/5/14, and it shows me automatically in the table all data between 9/5/14 and 11/5/14. So how can i obtain this result??

thanks

Gabry.

[Gysbert_Wassenaar · Accepted solution]

See this tutorial: Selecting Arbitrary Date Ranges

[SunilChauhan]

Load 

Day,

Seq,

Act,

File,

[File Refrence],

[Register Number]

from path where Day>=''9/5/2014' and  Day<='11/5/2014';

you may use and add remainig filed name you have in above code .

hope this helps

[amit_saini]

Hi Gabriele,

You can use script below to select date ranges: (Here in this case I'm considering from 2010 till date, you can change accordingly)

LET vMinDate = num(makedate(2010));

LET vMaxDate = num(today());

Datefield:

LOAD

    $(vMinDate) + IterNo() -1 as Datefield

AUTOGENERATE (1)

WHILE $(vMinDate) + IterNo() -1 <= $(vMaxDate);

Calendar:

LOAD

    Datefield as %Date,

    date(Datefield) as Date,

    year(Datefield) as Year,

    month(Datefield) as Month,

    day(Datefield) as Day,

    week(Datefield) as Week,

    weekday(Datefield) as Weekday

RESIDENT Datefield;

drop table Datefield;

Thanks,

AS

[its_anandrjs]

You can use calendar object for that for selecting the date ranges or simple if just write like below scripts in any date field list box to filter data quickly.

'>=9/5/2014 <=11/5/2014'