Hi Everyone,
How can I arrange chronologically a Month Field (Primary Field also) which is group and has this format 'MONTH YEAR' ?
Month Field, group and arrange chronologically
+29Airtable does not have a field that contains only a month and year.
Here are some workarounds.
- Use a date field, and enter all dates as the first of the month.
- If you have a date field elsewhere that you are trying to match, use a formula field that truncates the date to the first of the month. DATETIME_PARSE(MONTH({Date}) & "/1/" & YEAR({Date}), "M/D/YYYY")
- Use a single-select field. Values will sort in the order they are defined for the field. However, adding new months and years will require adding them to the field configuration.
- Use a single line text field, but add a prefix to get things to sort correctly, such as the numeric year followed by the numeric month, then the spelled out month. For example, "2024-01 | January 2024"
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.