Sheri, It's possible to compare them using DIGITS to convert the numeric date to a character format. The dates must be in the same format though and in YYMMDD format. If they are in MMDDYY format or the 8 byte date has 4 digit years you can't compare them. You can build a work date field using concatenate but that can get kind of complex. Check the archives for this list and the RPG list. Date comparison and conversion in SQL comes up pretty frequently. Rick
-----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rowe, Sheri Sent: Tuesday, November 28, 2006 1:57 PM To: midrange-l@xxxxxxxxxxxx Subject: Another SQL question. I need to update fields in FILEA based on a date comparison with FILEB. However, the date in FILEA is defined as 8A and the date in FILEB is defined as 6S. Is it possible to compare these fields even though they are not the same format? It's a one-time fix and I was hoping avoid writing a program. Thanks. Sheri Rowe Timex Canada
Privileged and Confidential. This e-mail, and any attachments there to, is intended only for use by the addressee(s) named herein and may contain privileged or confidential information. If you have received this e-mail in error, please notify me immediately by a return e-mail and delete this e-mail. You are hereby notified that any dissemination, distribution or copying of this e-mail and/or any attachments thereto, is strictly prohibited.