how to filter date in between

julkifli33 · **Posted:** Wed Aug 08, 2012 9:54 am

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 · **Posted:** Wed Aug 08, 2012 10:07 am

Put filter using

Quote:

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

julkifli33 · **Posted:** Wed Aug 08, 2012 10:24 am

mohana_cse06 wrote:

Put filter using

Quote:

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 · **Posted:** Wed Aug 08, 2012 12:12 pm

Wouldn't this work ?

Code: Select all

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

mibuso.com

how to filter date in between

Who is online