If you want the date to appear in the result, the code has to be in the select list before the FROM.
Select *,
SUBSTRING(DCBXDT, 4, 2) + '/' +
SUBSTRING(DCBXDT, 6, 2) + '/' +
SUBSTRING(DCBXDT, 2, 2) AS [Date Received]
FROM openquery(AS400, 'SELECT AEDCREP.DCKWCD,
AEDCREP.DCHSTX, AEDCREP.DCLYCD, AEDCREP.DCLXCD,
AEDCREP.DCCRTD, AEDCREP.DCBXDT, AEDDREP.DDLOCD,
AEDDREP.DDAIQT, AEDDREP.DDI2ST, AEDDREP.DDHTNB,
AEDDREP.DDH9ST, AEDDREP.DDH6NB, AEDDREP.DDK2CD,
AEDDREP.DDHUNB, AEDDREP.DDHNTX, AEDDREP.DDHSNB,
AEDDREP.DDKZCD, AEDDREP.DDK1CD, AEDDREP.DDIUST,
AEDDREP.DDCZNA, AEGDREP.GDAZCD,
AEGDREP.GDCMCE
FROM AEDCREP
INNER JOIN AEDDREP
ON AEDCREP.DCKWCD = AEDDREP.DDLOCD
INNER JOIN AEGDREP
ON AEDCREP.DCLYCD = AEGDREP.GDCMCE
WHERE AEDCREP.DCBXDT >1020201
AND AEDCREP.DCLXCD = ''ZOAGC09880''')
Terry L. Broadbent - Salt Lake City, UT
Home of the 2002 Winter Olympics (Feb 8-24)