+ Reply to Thread
Results 1 to 2 of 2

Thread: AS/400 file with ISO date and EXCEL 97

  1. 01-01-1995 02:00 AM #1
    Guest.Visitor Guest

    Default 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.
    Reply With Quote Reply With Quote
  2. 12-12-2000 12:08 PM #2
    Guest.Visitor Guest

    Default AS/400 file with ISO date and EXCEL 97

    Glen, Try using the CHAR() function. "Select Char(datefld,USA) From File" Bill
    Reply With Quote Reply With Quote
+ Reply to Thread

Similar Threads

  1. Excel date field to AS400
    By David Abramowitz in forum Microsoft
    Replies: 6
    Last Post: 07-15-2010, 11:13 AM
  2. Download Excel file to AS400 Physical File
    By Guest.Visitor in forum Networking
    Replies: 9
    Last Post: 10-19-2001, 02:15 PM
  3. AS/400 -> Excel 97 Date query
    By Guest.Visitor in forum Programming
    Replies: 2
    Last Post: 04-25-2001, 07:28 AM
  4. How do you generate an Excel file?
    By vrozen1 in forum Programming
    Replies: 2
    Last Post: 04-06-2001, 02:17 PM
  5. Excel Spreadsheet into AS/400 File
    By Guest.Visitor in forum Analysis
    Replies: 6
    Last Post: 09-19-2000, 01:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules