PC Review


Reply
Thread Tools Rate Thread

How can you format a date/time datatype to read month and year?

 
 
=?Utf-8?B?dHJhaW5lcjA3?=
Guest
Posts: n/a
 
      28th Mar 2007
For a field that has a date/time data type, how can I format (field
properties) the date so that it only shows month and year? In excel, I would
format the info using "mmyy". Is this the same in Access?
Thanks!
 
Reply With Quote
 
 
 
 
=?Utf-8?B?T2ZlciBDb2hlbg==?=
Guest
Posts: n/a
 
      28th Mar 2007
Try

Format([FieldName],"mmyy")

Or
Format([FieldName],"mm/yy")

Check help on the function Format, there are few options

--
Good Luck
BS"D


"trainer07" wrote:

> For a field that has a date/time data type, how can I format (field
> properties) the date so that it only shows month and year? In excel, I would
> format the info using "mmyy". Is this the same in Access?
> Thanks!

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
count month when date is in day/month/year format ccKennedy Microsoft Excel Worksheet Functions 6 30th Apr 2009 03:32 AM
Date format | Month/Year only changes to Day/Month/CurrentYear Paul Microsoft Access 6 23rd Mar 2007 01:27 PM
Format date with just month and year Jay3253 Microsoft Excel Misc 6 2nd Feb 2006 07:17 PM
How do I set the date format to day/month/year? =?Utf-8?B?U2lza2lu?= Microsoft Outlook Discussion 2 2nd Aug 2005 06:16 PM
Converting Date Time format to Month YEar format Prashant Sisodia Microsoft Excel Worksheet Functions 1 11th Jun 2004 03:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:28 AM.