Search Criteria where the column is a field or a calculation

rbuser

Hi,

I am using Delphi 6 + RBuilder 9.03.

I have a question that has been answered before.
-----------------------------------------------------------------
For instance where a records date is less than today's date -
recordDate < getdate()
or two fields recordDate < OtherRecordDate
-----------------------------------------------------------------

Nard Moseley answered this question on Mon, 27 Sep 2004 09:45:15 -0600 as
-----------------------------------------------------------------
1. To search against a field value, specify tablename.fieldname as the
search value. (i.e. the fieldname must be qualified with the table name).

2. To search agains the Current_Date value, try adding a calculated field
and then specifying the search condition as CalculateField >
TableName.FieldName.
-----------------------------------------------------------------
The original post shows it can be accomplished. But I tried (the 2nd
method) and it
doesn't work. Exception said the TableName.FieldName is not a valid date
string.

How can I put GETDATE() in?

Bin