Kbase 17361: Report Builder Using datefield w/ <> in IIF statement
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Report Builder Using datefield w/ <> in IIF statement
Customer was trying to use the IIF function to evaluate a date field
and was not able to get expected results.
For example:
created a calculated field with the following expression:
IIF(order.shipdate <> ?, "Y", "JOE") will print only "JOE"
but if you change the statement to:
IIF(order.shipdate = ?, "Y", "JOE") you will get the correct
results. ("Y" and "JOE")
amh 10/97
Progress Software Technical Support Note # 17361