leezac
asked on
Date field to mm/yyyy
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!!
Thanks in advance!!
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you!
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.
Microsoft Access
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.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Format( [DATE] ."mm/yyy")