Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Issue (2003)

    I have an Excel file that I import into an Access database. In the Excel file there is a date field that looks like 12/02/08 but when it comes into Access it looks like 12/02/2008 12:35:58 PM. I can't seem to get rid of the time. I formatted the date to date in Excel but nothing works. How can I remove the time? I can't see it in Excel.

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Date Issue (2003)

    In Access, a data/time field is actually a number in which the date is represented by numbers to the left of the decimal and the time by numbers to the right of the decimal. You can eliminate the time by just doing an Update query and rounding the value to 0 decimal places. Like this:

    UPDATE yourTable SET yourDate = round(yourDate,0)

    Of course, backup your database before doing any data manipulation like this, just in case.

    As for displaying dates, without any special formatting, Access uses your Windows date format as the default. This is just a formatting issue, it doesn't affect the data.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Issue (2003)

    Thank you - I will try that.

  4. #4
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Issue (2003)

    In addition to Mark's suggestion (and always back up your tables first), you could also modify the table in design view, and change the field's properties.
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

Posting Permissions

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