Grouping dated records by Month-Year

[KnoxMuseumEd]

Hi! I am using Airtable to create an inventory of items in a museum of education related items. The vast majority of the items in our collection only have a year attributed to the item (i.e. class of '89, picture taken 1976, Spring 1935, etc). I am wanting to create a timeline view to show a history of certain schools, subjects, and other grouping criteria. Is there a way to have just a year (YYYY) be read as a date for timeline and gantt purposes? 

[Databaser]

Yes. If you use 

DATETIME_PARSE(DATETIME_FORMAT({date field}, "YYYY"))

it will show up as 01/01 in the year in question. {date field} could be replaced with an actual number like "2024" (including the " " ).

[Sho]

Hi @KnoxMuseumEd,

If there is only one number in the description, extraction is easy.
When multiple numbers are present, more detailed conditions are required.

SWITCH(
  LEN(REGEX_EXTRACT({description},"\\d{2,4}")),
  2, VALUE(REGEX_EXTRACT({description},"\\d{2,4}"))+1900,
  4,VALUE(REGEX_EXTRACT({description},"\\d{2,4}"))
)