Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Format a date (access 2003)

    Not sure if this is possible but I need to reformat the date below to a more user friendly format. I'm working with the same text file I mentioned in an earlier post. I was able to rename this file and import it into a table called siteinfo. The field is called date. Is there a way to update all the dates in the date field to this format : 09/24/2005 or 09-24-2005? P.S. Thanks for the help on the rename issue. I appreciate it....

    2005-09-24

  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: Format a date (access 2003)

    The information in a date field is not stored in a formatted format. Dates are formatted when you show them. So, change the default format in the table for this field, or assign specific formatting when you use this field on a form or report.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Format a date (access 2003)

    I assume that you have specified YMD order for the relevan field when you imported the text file (by clicking Advanced...). The field will then be imported as a date/time field. As Mark Liquorman already wrote, you can set the Format property of the field; this determines how it is displayed on screen and in printouts.

Posting Permissions

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