Table Design to use Date field and only place in Month Year

[healey21]

I am designing a new table and looking to record the month and year in the field. Example an Exchange rate Month July Year 2011.

I created:
Field ExMonth
DataType Date/Time
Formatted to mmmm yyyy
input mask to 00/00

when I enter date like 03/11 it returns it as November 2011 rather than March 2011 ?

 

[Trevor G]

Other than a text box you could use a Date/Time field, place in the format that you want but don't mask it. You should get a date picker then and when the date goes into the Field it will be formatted accordingly.

You can then run queries to ensure you pick the month for the data.

Hope that helps..

 

[Norie]

If you just enter 3/11 the year will automatically be added and default to the current year.

Can you not just enter a full date?

That would be easy to format, sort/group by etc.

 

[healey21]

Thank you Norie and Trevor G for your suggestion.

I have made a table and placed in a field monthyear and added a autonumber so that I can keep the order as entered.

Then linked to the Field in the table and added a form so it can be updated.