Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    93

    Unanswered: date field problem

    hello freinds

    i am trying to import a .txt file which has a field for datetime
    for example:06/11 16:05:46 pm

    the purpose of this field is to sort data with respect to the newest data

    is there a way i can define my old datatime field ??

    i tried importing bt to vain ..

    any suggestions would be appreciated

    thanks,
    sam

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    06/11 is not a date. What year is that?

    is there a way i can define my old datatime field ??
    I don't understand this question.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Nov 2007
    Posts
    93
    its 2009

    thats my concern.. the year isnt there

    if that would have been there.. then i would have sorted easily with the help of queries .. newest to oldest...
    bt as the year isnt there.. i need to luk fr some other solution

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    if this is a one off then I'd suggest import it as text into a separate table

    then run an insert query that stuffs the new values into the existing table and reformats the text value to include the year. note if you are outside the thrall of sceptic land you will need to may the date mm/dd/yyyy or yyyy/mm/dd.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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