Search Criteria where the column is a field or a calculation

rbuser

RB7.04 D6 End User Reporting with DADE

Is there a way, or are there plans for a way, to define a search
criteria in DADE to compare two fields or to compare against an
expression.

For instance where a records date is less than today's date -
recordDate < getdate()
or two fields recordDate < OtherRecordDate

In my tests DADE tries to coerce the getdate() string to be a date,
fails and blanks it out.

Thanks,
Rick Matthews
Dartek Systems Inc.

nardmoseley

The current limitions are

- You cannot specify a function as a search value
- You cannot specify a calculated field as a search value

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.




--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com

rbuser

Thanks Nard, that works well enough for me.

Cheers,