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:='????'+'<=20010901';
PS sorry for my poor English.