date filtering a table component

dick Walker

Delphi Developer

Mon, 09 Oct 2000 03:00:00 GMT

date filtering a table component

I am a Delphi novice, trying to filter records for a quick report.

- I have a table component
- I am trying to set the filter property
- I started by hard coding the property as follows
([date] >= 04-20-98)
where date is my field name, but I get an invalid date prompt, also tried
([date] >= 20-04-98) as I would with my dates set to Australian format but
no luck.
- I'm using Delphi 2.0 desktop / std

Can anyone help?

Thanks

dick Walke

Delphi Developer

Mon, 09 Oct 2000 03:00:00 GMT

Re:date filtering a table component

I am a Delphi novice, trying to filter records for a quick report.
- I have a table component
- I am trying to set the filter property
- I started by hard coding the property as follows
([date] >= 04-20-98)
where date is my field name, but I get an invalid date prompt, also tried
([date] >= 20-04-98) as I would with my dates set to Australian format but
no luck.
- I'm using Delphi 2.0 desktop / std
Can anyone help?
Thanks

Christopher di Arma

Delphi Developer

Sun, 15 Oct 2000 03:00:00 GMT

Re:date filtering a table component

Quote

"dick Walker" <di...@pcug.org.au> wrote:
>>- I have a table component
>>- I am trying to set the filter property
>>- I started by hard coding the property as follows ([date] >= 04-20-98)
>> where date is my field name, but I get an invalid date prompt, also tried
>> ([date] >= 20-04-98) as I would with my dates set to Australian format
>> but no luck.
>>- I'm using Delphi 2.0 desktop / std

There are a couple of things that need to be done. First, you have to
use compatible types for the evaluation. Second, you have to make sure
the date format and date separator are what your program expects. I
_always_ set ShortDateFormat and DateSeparator in my programs instead
of relying on the windows settings.

So, for example, if your date field is named Date1, you would use the
following when hard-coding if your property

ShortDateFormat := 'DD-MM-YY';
DateSeparator := '-';
if Table1Date1.AsDateTime >= StrToDateTime('20-04-98') then ...

Hope that helps...

Christopher di Armani
diarm...@yahoo.com

Other Threads

1. date filtering a table component

2. Table.Filter: Filtering between dates

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

4. Tables -- How to Filter dates ?

5. Table 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