Date field to mm/yyyy

leezac used Ask the Experts™
I need a query or input mask to change the date field in the table in the attached database to show mm/yyyy only.  I tried an update query but did not update.

Thanks in advance!!
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Open your table in design view. In the date field under format enter mm/yyyy

Or if you want it in a query you can use:

Format( [DATE] ."mm/yyy")


Thank you!
Top Expert 2010

If you use Format() as suggested above, I recommend using yyyy/mm instead: if you ever sort on that column, using yyyy/mm will guarantee a proper sort order.  If you use mm/yyyy instead, then a value such as 02/2013 will sort ahead of 12/1950.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial