Board index » delphi » Table filter dates

data_wiz...@hotmail.com (Tony)

Delphi Developer
Fri, 26 Mar 2004 11:09:31 GMT

Table filter dates

Can someone tell me how to correct this?  When I code this filter with
this line of code.  I get this error:

Table1.Filter := ('EVENT_DATE'  >  datetostr(AstartDate))  AND
('EVENT_DATE'  <  datetostr(AEnddate));

Error returned: [Error] Unit1.pas(64): Incompatible types: 'String'
and 'Boolean'

Coded this way:

Table1.Filter := '(EVENT_DATE  >'  datetostr(AstartDate))  AND
'(EVENT_DATE <'  datetostr(AEnddate));

Error returned:  "Arithmetic"

 
David Atki

Delphi Developer
Sun, 28 Mar 2004 10:27:25 GMT

Re:Table filter dates


Try to adjust your quotes to yield a concatenated string:

  Table1.Filter := '(EVENT_DATE >'+ datetostr(AstartDate) +
                          ')  AND (EVENT_DATE  <'  +
datetostr(AEnddate)+')';
This should work for you.

David

Quote
"Tony" <data_wiz...@hotmail.com> wrote in message

news:47adb77.0110071909.2d867942@posting.google.com...
Quote
> Can someone tell me how to correct this?  When I code this filter with
> this line of code.  I get this error:

> Table1.Filter := ('EVENT_DATE'  >  datetostr(AstartDate))  AND
> ('EVENT_DATE'  <  datetostr(AEnddate));

> Error returned: [Error] Unit1.pas(64): Incompatible types: 'String'
> and 'Boolean'

> Coded this way:

> Table1.Filter := '(EVENT_DATE  >'  datetostr(AstartDate))  AND
> '(EVENT_DATE <'  datetostr(AEnddate));

> Error returned:  "Arithmetic"

Other Threads

1. Table.Filter: Filtering between dates

2. Table.Filter: Filtering between dates - Help needed!!!

3. date filtering a table component

4. date filtering a table component

5. Tables -- How to Filter dates ?

6. Dates in database and Table filter

7. How to Filter a Date on a table

8. How to filter a table with Date

9. Filter date in AdoDataset - problem weith dates

10. Input a date&filter data according to date