ka1a
asked on
Using property filter with table component
I want to filter a database with a date (filter is the only way with the tablecomponent I have to use (btrieve database). Query is not possible. The only fields I can use for this are three stringfields. The day (string of 2: ex. '08'), month (string of 2: ex. '04') and year (string of 2: ex. '99'). There are always 2 characters. The formule I hope to use is '<=20010901' where the first four characters are the year, the next two the month and the last two the day of the month.
How can I do this. I hope someone can help me. The examples above should have to give as result:
'19990408<=20010901' so this record should be axcepted. I can't configure this out. Does anyone knows which formule I have to use to get this working. I want to use in my code: table1.filter:='????'+'<=2 0010901';
Please help.
Dirk.
PS sorry for my poor English.
How can I do this. I hope someone can help me. The examples above should have to give as result:
'19990408<=20010901' so this record should be axcepted. I can't configure this out. Does anyone knows which formule I have to use to get this working. I want to use in my code: table1.filter:='????'+'<=2
Please help.
Dirk.
PS sorry for my poor English.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again.
Dirk.