Results 1 to 2 of 2
  1. 02-01-2016, 02:51 PM #1
    accessmatt
    accessmatt is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    199

    Formatting date in a query


    Hello, can anyone remind me how I can format a date field in a query to only show MM-YY?

    Thanks,
    Reply With Quote Reply With Quote
  2. 02-01-2016, 02:57 PM #2
    JoeM
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Try:
    Code:
    FORMAT([DateField],"MM-YY")
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Date formatting in an Access 2010 query
    By cliff.clayman in forum Access
    Replies: 5
    Last Post: 11-25-2015, 11:46 AM
  2. sintax for formatting date to normal date in a query expression field
    By edson in forum Access
    Replies: 3
    Last Post: 12-02-2014, 07:58 PM
  3. Date/Time Formatting
    By cuddles in forum Access
    Replies: 5
    Last Post: 06-11-2014, 02:44 PM
  4. Date Conditional Formatting
    By f15avionics in forum Access
    Replies: 3
    Last Post: 09-21-2012, 04:45 AM
  5. Formatting a date
    By NISMOJim in forum Queries
    Replies: 7
    Last Post: 09-17-2010, 05:44 PM

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