Results 1 to 2 of 2
  1. 04-01-2011, 02:12 PM #1
    bulbul4u
    bulbul4u is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2011
    Posts
    3

    How to Change Date Format

    Hey All,



    How can I change the date format in access 2007?
    Currently, I have the following format: 12/18/1983
    Need to change to: 19831218

    Need assistance friends,


    thanks
    Reply With Quote Reply With Quote
  2. 04-01-2011, 03:02 PM #2
    kennejd
    kennejd is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    188
    format(yourdate,"yyyymmdd")
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Change field format
    By zhshqzyc in forum Access
    Replies: 6
    Last Post: 01-20-2011, 04:07 PM
  2. Can i change the format of DATE () ?
    By Nokia N93 in forum Access
    Replies: 2
    Last Post: 11-27-2010, 01:34 PM
  3. Date Format
    By lonewolfwfk in forum Programming
    Replies: 4
    Last Post: 11-25-2010, 09:00 PM
  4. Date Format
    By wasim_sono in forum Forms
    Replies: 2
    Last Post: 08-15-2006, 01:20 AM
  5. Date Format
    By St3ph3n in forum Access
    Replies: 4
    Last Post: 03-09-2006, 11:23 AM

Tags for this Thread

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums