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

's Computer Specifications

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!

's Computer Specifications

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!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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