I have this code...

DEFINE FILE PE_HHIORDDP
TAB_LABEL/A20 = IF (FFJQOHH + FFJQOBC) NE 0 THEN '1-BACK IN STOCK' ELSE
IF (FFJQCXP) NE 0 THEN '2-PO SCHEDULED' ELSE '3-OUT OF STOCK';
NEXT_PO_DATE/I9 = IF TAB_LABEL EQ '1-BACK IN STOCK' THEN 0 ELSE FFJDTEQ;
END

TABLE FILE ...
...
BY LOWEST PE_HHIORDDP.PE_FFJITMBP.NEXT_PO_DATE AS 'Next PO Date'
BY LOWEST PE_HHIORDDP.PE_FFJITMBP.TAB_LABEL
...
END

Which gives me these results...

Next PO Date
0
20160525
20160526
20160523
20160517
20160517
20160517
20160520
0
20160428
20160413
20160601
20160520
20160413
20160525
20160517
20160517
20160518

So I change the code to provide the date format MM/DD/YYYY...

DEFINE FILE PE_HHIORDDP
TAB_LABEL/A20 = IF (FFJQOHH + FFJQOBC) NE 0 THEN '1-BACK IN STOCK' ELSE
IF (FFJQCXP) NE 0 THEN '2-PO SCHEDULED' ELSE '3-OUT OF STOCK';
NEXT_PO_DATE/I9 = IF TAB_LABEL EQ '1-BACK IN STOCK' THEN 0 ELSE FFJDTEQ;
OLD_DATE/A8=EDIT(FFJDTEQ,'$$$$$99$$')||EDIT(FFJDTEQ,'$$$$$$$99')||EDIT(FFJDTEQ,'$9999$$$$');
NEW_DATE/A8DMYY=OLD_DATE;
END

TABLE FILE...
...
BY LOWEST PE_HHIORDDP.PE_FFJITMBP.NEW_DATE AS 'Next PO Date'
BY LOWEST PE_HHIORDDP.PE_FFJITMBP.TAB_LABEL
...
END

In which I get these results...

Next PO Date
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
06/01/2016
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
31/12/1900
05/18/2016

What is going on here? The new code I made worked fine in another procedure. AS you can see a couple of dates came out normal but not the rest.

This message has been edited. Last edited by: <Emily McAllister>,

I used NEXT_PO_DATE/I8YYMD and it worked in this format other then the YY needs to be at the end.

Turned out to being a character amount issue. Instead of A8, I used A15 and it worked. Lame...

FYI

31/12/1900 is effectively a NULL smart date.