date formatting prob (1 Viewer)

[jojo]

I can't get a date field to display the month andyear. In the form format box, I worote mm/yy. when i type that in the form it interprets 8/15 as august 15 2013 instead of August 2015.
this should not by hard. Thank you to all of you for your wonderful answers!
Access 2010 win 7
jojo

 

[John Big Booty]

The only way I can see of getting around that would be to type in the year explicitly as 08/2015, which access will interpret as August 1 2015. If you only type in 08/15 Access will interpret that as August 15 of the current year.

 

[gemma-the-husky]

you could use a date picker.

 

[jojo]

Thank you, John Big Booty for the answer about the date formatting you posted back on 3/1, which I just discovered. It's hard to understand how Access doesn't have the capability of accepting a date formatted as mm/yy. I am using mm/yyyy, which is more bother for the user to have to type in all 4 year digits. The date picker would take even longer.
thank you for all your super answers
Jojo

 

[jojo]

Thank you gamma-the-husky for your answer of 3/1. The problem with the date picker is that the dates would be a different month and year, and would require much time-consuming arrow clicking to get to the right year and month.
Thank you for replying!
Jojo