Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

AS/400 file with ISO date and EXCEL 97

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • AS/400 file with ISO date and EXCEL 97

    I have a file on the AS/400 that contains an ISO date (yyyy-mm-dd). EXCEL does not seem to be able to recognize it as a date. Is there a way to get excel to recognize this as a date or do I have to change it on the AS/400 before downloading.

  • #2
    AS/400 file with ISO date and EXCEL 97

    Glen, Try using the CHAR() function. "Select Char(datefld,USA) From File" Bill

    Comment

    Working...
    X