I filter a database using the following code taking dates from two
datetime pickers.
DateFilter := 'Solddate >= ''' + Datetostr(dates.First.datetime) + '''';
DateFilter := DateFilter + ' AND Solddate <= ''' +
Datetostr(dates.last.datetime);
items.filter := datefilter;
The problem is that it does not filter right.
I set shortdateformat to dd/mm/yyyy and it worked better but it is still
incorrect when selections are made from multipule months.
The tables are paradox 7.
Any help gladly accepted,
James
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
