Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Date Formating

Discussion in 'Information Technology' started by Chris, Jul 28, 2006.

Tags:
  1. Chris

    Chris
    Expand Collapse
    Guest

    Is there a way in a query or after doing a make table query to change the
    date formating? I need to change all the dates of a data set, without
    changing the table, so in a query or a new table, that is a make table query.
    I need to change them from the format of 7/18/2005 to 07182005. Does
    anyone have any suggestions???
    Thanks,
    Chris
     
  2. Loading...


  3. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Chris,

    Have you tried a format like this: ddmmyyyy


    Tom Wickerath, Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Chris" wrote:

    > Is there a way in a query or after doing a make table query to change the
    > date formating? I need to change all the dates of a data set, without
    > changing the table, so in a query or a new table, that is a make table query.
    > I need to change them from the format of 7/18/2005 to 07182005. Does
    > anyone have any suggestions???
    > Thanks,
    > Chris
     
  4. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    No problem - you do not format dates in a table - only in the display such as
    query, form, or report.
    Format([YourDateField],"mmddyyyy")

    "Chris" wrote:

    > Is there a way in a query or after doing a make table query to change the
    > date formating? I need to change all the dates of a data set, without
    > changing the table, so in a query or a new table, that is a make table query.
    > I need to change them from the format of 7/18/2005 to 07182005. Does
    > anyone have any suggestions???
    > Thanks,
    > Chris
     

Share This Page