<div>
Or if you want it in a query you can use:<br />
<br />
Format( [DATE] .&quot;mm/yyy&quot;)
</div>


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

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

<div>
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. &nbsp;If you use mm/yyyy instead, then a value such as 02/2013 will sort ahead of 12/1950.
</div>


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.

<div>
<div class="content wysiwyg-content">
I need a query or input mask to change the date field in the table in the attached database to show mm/yyyy only. &nbsp;I tried an update query but did not update.<br />
<br />
Thanks in advance!!
</div>
</div>


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!!

Date field to mm/yyyy

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.