format column in table

[tmcrouse]

I know in creating columns in a table where I have date/time you can select long short, etc. But, I want my column name to be YR and the values of 2014, 2015, 2016, 2017 all the way to 2020. So I end up with 7 rows. Then another date related table that houses the months. It will have a column name of MTH and the values Jan through Dec so a total of 12 rows. I have tried in format putting YYYY and MMM but when entering the data, it gives me an error saying I have to convert, ask for help or click the calendar and choose a date. I don't want to choose month, day and year. I just want the year.

[June7]

Calendar picker only works with a date field. Just the year or month or day is not a date entity. Cannot save just those parts into a date/time field.

Either save the date value with all date parts into a single date/time field or use number type fields to save the parts, in which case can't use date picker. Can, however, set combobox with a RowSource that is a ValueList.

[orange]

Not sure of your real requirement, but you can store a date in the field; then use the Year() function to display/select only the Year portion. Similarly with the Month() and Day() functions.