Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    154

    Talking Unanswered: Number to Date conversion silliness

    I'm about to lose my mind... I've been trying to convert a number field to a date. No matter how I slice it, the date comes out waaay off!

    For example,

    200402
    turns into 2448/09!

    Plus, if I try to convert a MONTH field (1 - 12 are the values), it screws that up as well!

    And so on...

    I've looked but no find answer. It does this in excel as well.

    please help me obi wan, you're my only hope...

  2. #2
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    154

    Thumbs up I think I found it...

    I realize after retracing my steps that the data I imported started out as a .CSV file. Upon re-importing, I noticed that the mainframe app that exported the data slapped quotes around the date fields, but once imported I couldn't see the quotes... so it was limiting access' ability to produce a proper conversion!

    Argh, only a few hundred of these files did I import!!

Posting Permissions

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