I have two date fields on two master files both defined as HYYMDS. Use the dates as parameters works fine. When I try to use one of the dates in a define I get an error.

 IF PAY_DATE LE DUE_DATE THEN POS_ICON ELSE IF PAY_DATE GE DUE_DATE THEN NEG_ICON ELSE NEU_ICON 

The error is cannot compare alphanumeric with numeric. That is true but neither one of them is alphanumeric. Any thoughts?

This message has been edited. Last edited by: kerry,

Can you post the portions of the master with the date fields and POS_ICON and the DEFINE?

 '<img src=/approot/CENTEST/trendPos.gif>' 

This is the define for the POS_ICON. I don't know how to post the master file.

Open the master up in the text editor and copy and paste the lines with the dates in them.

And post the entire DEFINE statement including all the text from your original post and the field you are setting up to the left of the equal sign, i.e.

DEFFLD/someformat=IF PAY_DATE LE DUE_DATE THEN POS_ICON ELSE IF PAY_DATE GE DUE_DATE THEN NEG_ICON ELSE NEU_ICON;

try entering

??F [masterfile name]
-EXIT

to get a list of all fields and their formats in that data source- check both are actually dates, if you don't know how to access the master you can't be sure that they are date formats and this will allow you to see the formats from the fex you are writing...

Tracie,

Are PAY_DATE and DUE_DATE both defined as HYYMDs?

I think you have to use HDIFF and compare to 0 to check wf date time stamp IIRC.

Could be wrong. wf Datetimes are not one of the great features of the product - they should have copied what Oracle did instead they went the function based approach of SQL Server.

When I hover over both dates on the master files both are defined as HYYMDS. I reformatted them on the report to display as MMDY.

 DUE_DATE/MDYY AS 'Due Date'
     PAY_DATE/MDYY AS 'Date Paid' 

  WHERE ( PAY_DATE GE DT(&Beginpaydate.From Paid Date.) ) AND ( PAY_DATE LE DT(&todatepaid.To Date Paid.) );

This is the error I get trying to run the report.0 ERROR AT OR NEAR LINE 29 IN PROCEDURE customer_invoice_r
(FOC282) RESULT OF EXPRESSION IS NOT COMPATIBLE WITH THE FORMAT OF FIELD:
PAY_DATE
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND

try reformatting pay_date hyymds to yymd.
PAY_DATE1/YYMD = HDATE(PAY_DATE, 'YYMD');

quote:

try reformatting pay_date hyymds to yymd.
PAY_DATE1/YYMD = HDATE(PAY_DATE, 'YYMD');

This worked. This one is solved. Thanks to all.