Welcome to SPN

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

Sign Up Now!

Date format in update query

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

  1. John

    John
    Expand Collapse
    Guest

    Hi

    How can I ensure that date is always assigned in dd/mm/yyyy format to a date
    filed, in an update query?

    Thanks

    Regards
     
  2. Loading...


  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    John, Access does not store dates in a specific format. The format is
    applied at display time, and depends on the user's Regional Settings (in the
    Windows Control Panel.)

    So perhaps your question is, "How can I ensure that Access understands the
    dates in the query, and stores the correctly when the Update query
    executes?"

    I also live in a d/m/y country, and in 15 years of working with Access have
    found 3 cases where Access is likely to misunderstand our dates. Details in:
    International Date Formats in Access
    at:
    http://allenbrowne.com/ser-36.html

    If the dates are calculated ones, typecasting them in the query can also
    help:
    Calculated fields misinterpreted
    at:
    http://allenbrowne.com/ser-45.html

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "John" <John@nospam.infovis.co.uk> wrote in message
    news:eRyOzMnlGHA.4708@TK2MSFTNGP04.phx.gbl...
    >
    > How can I ensure that date is always assigned in dd/mm/yyyy format to a
    > date filed, in an update query?
    >
    > Thanks
    >
    > Regards
     

Share This Page