Filtering data by Date

m.pacana

Is it possible to filter my data in the table box by date? Is it possible doing this using the SetFilter property? I have done it by this code:
TableName.SETFILTER(TBLCol_Date, '>myDate');

NOTE: myDate is a global variable. this code should filter records having a
TBLCol_Date later than my global variable myDate? 8)

Is this the right way to code this? :-k

ara3n

TableName.SETFILTER(TBLCol_Date, '>%1',myDate);

m.pacana

Thanks so much ara3n! \:D/

DrWatson

This also works:

TableName.SETFILTER(TBLCol_Date, '%1..',myDate);

or

TableName.SETRANGE(TBLCol_Date,fromDate,toDate);

kriki

Be carefull:
TableName.SETFILTER(TBLCol_Date, '>%1',myDate); // means TBLCol_Date > myDate
and
TableName.SETFILTER(TBLCol_Date, '%1..',myDate); // means TBLCol_Date >= myDate

m.pacana

Thanks guys! \:D/