how to filter date in between

julkifli33

hi all
i want to filter date in between
i have data like this
entry no 1 = starting date 01/08/2012,ending date 31/08/2012
entry no 2 = starting date 01/09/2012,ending date 30/09/2012
entry no 3 = starting date 01/10/2012,ending date 31/10/2012

so if i put date as 15/09/2012, then it will go to entry no 2
and if i put date as 02/08/2012, then it will go to entry no 1

and clue?

mohana_cse06

Put filter using

CALCDATE('<-CM>',<your input>)
CALCDATE('<CM>',<your input>);

julkifli33

mohana_cse06 wrote:

Put filter using

CALCDATE('<-CM>',<your input>)
CALCDATE('<CM>',<your input>);

hi mohana,
that's good idea
but how about the data is not monthly

let say start date 01/10/2012,ending date 06/10/2012

MBerger

Wouldn't this work ?

record.SetFilter("Starting date",'..%1',SearchDate) ;
record.Setfilter("Ending Date",'%1..',Searchdate)  ;