Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exporting Date w/o Time in a Table (MS Access 2002)

    Hi!
    I know that no matter what format you use for date, that the "time" is still in the backgroud and unfortunately time displays when I'm exporting to a .txt or .csv. Any ideas on how to remove "time"? Thanks in advance for your assistance. <img src=/S/bummer.gif border=0 alt=bummer width=15 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Exporting Date w/o Time in a Table (MS Access 2002)

    You could create a query and define a calculated column like this:
    <code>
    FormattedDate: Format([NameOfDateField],"mm/dd/yy")
    </code>
    Substitute appropriate names, and change the format string to your preferred format.
    Export the query instead of the table.

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exporting Date w/o Time in a Table (MS Access 2002)

    HansV!
    You are the best! Thanks a bunch! I wonder why MS has this lil wonder (time) visible in the background and it's only a pain when exporting to .txt or .csv
    <img src=/S/bubbles.gif border=0 alt=bubbles width=31 height=17>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Exporting Date w/o Time in a Table (MS Access 2002)

    It has to do with the way dates and times are stored: as a number, where the integer part of the number represents the number of days since an arbitrary starting point (most Windows programs use December 30, 1899 as "0"), and the fractional part represents the time (e.g. 0.25 = 6:00 AM). This way, a complete date+time can be stored in a single number, which is very handy for calculations.

Posting Permissions

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