How to group bases by month

Help
1

Hi,

ist there a way to group bases by month or year or month-year? I don’t know the formular. I have a property with date and time in it. It is called “Created”.

Thanks in advance.

Mick

2

Here’s one way.

Make a Properties formula that’s [Created.year, Created.month]. Then group by that formula.

```base
formulas:
  group: "[Created.year, Created.month]"
views:
  - type: table
    name: Table
    groupBy:
      property: formula.group
      direction: ASC
    order:
      - file.name
      - Created

```
2 Likes
3

That did the job. Thank you very much, have a great day.

1 Like