Kbase P23089: Dynamics: Date calculation in parent filter query does not w
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/04/2003 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.0A
SYMPTOM(s):
Dynamics: Date calculation in parent filter query does not work.
No records are returned in Dynamic Lookup or Combo.
CAUSE:
The syntax for the date expression within the parent filter query is not correct. For example where '&1' is a date field:
employee.firstname = 'Andrew' AND employee.startdate = '&1 - 10'.
FIX:
When '&1' is a date field the expression should be:
employee.firstname = 'Andrew' AND employee.startdate = &1 - 10
If '&1' is a character field representing a date, then the expression would be:
employee.firstname = 'Andrew' AND employee.startdate = DATE('&1') - 10