Convert date in Access 2003

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • RookieDan
    New Member
    • Nov 2006
    • 8

    #1

    Convert date in Access 2003

    Dear all,

    hope to get lucky with you..

    Have normal Access 2003 DB. It has a standard table with one column showing dates in DD.MM.YYYY format.

    I hate that format and tries to convert it to standard: YYYY-MM-DD

    I have used a SQL query that imports all posts without conditions to a new table, and then I have tried to use some SQL tricks to reformat the Column Date into the new format - but this doesnt really work for me.

    Can you solve it with VBA?

    Please impress me and give me some hints!

    //DAniel
  • flacop
    New Member
    • Mar 2007
    • 1

    #2
    Visual Basic the command is- format(date-to-be-formated, "yyyy/MM/dd mm:ss tt" . That will take your string of "01/01/2001 12:00:15 PM" and convert it to "2001/01/01 12:00:15 PM".

    Comment

    • willakawill
      Top Contributor
      • Oct 2006
      • 1646

      #3
      This has already been answered in another thread so I am closing this one.

      Comment

      Working...