Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

AS/400 file with ISO date and EXCEL 97

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    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.
    Tags: None
  • #2
    AS/400 file with ISO date and EXCEL 97

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

    Comment

    Previous template Next
    Working...
    X