Hi !
Coleagues, I have a project in AirTable in a single table with 174 rows and 11 (eleven) categories that I can group these rows.
Each of these 174 tasks has its own "Start Date" and "End Date" column, with date format in it.
I want to know the earllier "Start Date" and the latest "end Date" inside each of these modules, when filtered by them.
(The objective is to show a timeline filtered by these "MODULES", using these fields with this formuila that identifies the earliest and the lates dates... I'm open to other approachs).
I achieve the first step with these two formulas. They returns the date in each of these fields for its row:
1 - For the earliest "Start date" it is:
MIN( VALUE(DATETIME_FORMAT({Start date}, 'MM/DD/YYYY')) )
2 - For the latest "End date" it is:
MAX( VALUE(DATETIME_FORMAT({End date}, 'MM/DD/YYYY')) )
But !!...
These formulas, based in the columns (fields) "start date" and "end date",
returns the date of the row they are inserted.
e.g.1: If the "start date" of the row is 9/13/2023 it returns 9/13/2023.
e.g.2: If the end date of the row is 1/31/2024, this formula returns 1/31/2024.
It is not what I want.
I want this formula to bring the earliest date in the entire column called "Start Date" and that brings the latest date that is in the column (field) "End Date).
How to achieve it?
PS: The second step will be to get such earliest and lates dates from the 11 groupped modules I have.
PRINT OF THE TABLE:
