1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Solved: Access97 Date conversion

Discussion in 'Business Applications' started by ddw23, Sep 15, 2006.

Thread Status:
Not open for further replies.
  1. ddw23

    ddw23 Thread Starter

    Joined:
    Jan 19, 2006
    Messages:
    109
    Hello everyone. Help me please!!! :confused:

    I imported a text file with date fields. The fields import as text (20060123 - yyyy mm dd). I need to convert the text date into a date format to view as 1/23/2006. I would like to convert it using a query. However, I'll take whatever is the best solution!
    There are over 192 thousand records. I'm working in Access97 unfortunately.

    THANK YOU in advance to everyone who responds and tries to help!!!!
    It's VERY MUCH APPRECIATED!!!
     
  2. OBP

    OBP It's My Birthday!

    Joined:
    Mar 8, 2005
    Messages:
    19,895
    I can write you a query or some vba to do this, but I need to know the exact name of the Table and the date field.
     
  3. ddw23

    ddw23 Thread Starter

    Joined:
    Jan 19, 2006
    Messages:
    109
    This has been solved. For anyone interested, here is the fix I used.
    DateSerial(Left([Date],4),Mid([Date],5,2),Right([Date],2))
    Where "Date" is the name of the field that has the text you want to change.
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/501441

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice