Announcement Module
No announcement yet.

CYYMMDD format download to MS Access

Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • CYYMMDD format download to MS Access

    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

  • #2
    CYYMMDD format download to MS Access

    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