Avatar of leezac
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!!
Microsoft Access

Avatar of undefined
Last Comment
Patrick Matthews

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Flyster

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Flyster

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

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

ASKER
Thank you!
Patrick Matthews

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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23