Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Is it possible to allow a "Date" formatted record to only display the year?

921 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Eskin
6 - Interface Innovator
6 - Interface Innovator

When choosing a "Date" column, it only lets me add a specific DAY and time... but what if I ONLY want to add the year. Or a month and year. Is that possible?

2 Replies 2
John_B2
6 - Interface Innovator
6 - Interface Innovator

You have to create another column with a formula using DAY(), MONTH or YEAR() functions.

Are you starting with a full date and want to extract only the year or month/year? If so, use a formula field to extract the parts of the date you want. As John said, you can use DAY(), MONTH(), or YEAR() to get numeric versions of those values. You can also use DATETIME_FORMAT() to get a text string with any combination of date information that you want. These are all documented in the formula field reference.

On the other hand, it sounds like you only know the year, or possibly only the month and year, and not the full date and want to know how to represent that data in Airtable. If this is the case, you cannot use a date field. In these cases I usually use a number, text, or single-select field to represent the year, and a single-select to represent the month. Unfortunately, if you use a single-select to represent the year, you are limited to which years you can include based on the single-select choices. On the other hand, if you use a number or text field for the year, you risk getting an invalid entry for the year.