CYYMMDD format download to MS Access

01-01-1995, 02:00 AM

I am having trouble with some of my users and their processes. They are downloading data from the AS400 via Client Access. They then upload this data to MS Excel and MS Access '97. The dates are downloaded in "CYYMMDD" format. This did not cause a problem processing 20th century dates, because the "C" will be a zero which Excel and Access suppresses. Now that they, the users, are processing 21st century dates, the "C" is a 1. Now Excel and Access say this is an invalid date. I am trying find a fix for the problem with out changing the 400. I have looked at a tool by Data Junction that seems to help transfer the data to the PC with the correct dates. If anyone else has any suggestions, they would be appreciated

If the file transfer is "saved", it may be possible to tune the transfer process by using the CHAR token with the date field. This means that each field will have to be defined individually to the transfer, instead of "*". Dave