Looker Studio calculated field – Older date from a date field
May 3, 2022
- by Mehdi Oudjida
The Looker Studio (ex Google Data Studio) calculated field below returns the older date from a date dimension. The min date in other words.
Most recent date
PARSE_DATE("%Y%m%d",MIN(Date))
-
Explanations of the formula step by step
- Get the older date of the date field using MIN function that returns a numeric output
- Parse the numeric to cast it as a date using PARSE_DATE function
-
Input
- Any date type dimension
-
Output
- The older date
- Used functions