Function 1: DATE

This function allows you to generate a date field from numerical inputs or from a date-time expression. It is particularly useful when the data source hasn’t been formatted as a date.

DATE(2022, 03, 03)

The output in Looker Studio will display the corresponding date.

Function 2: PARSE_DATE & PARSE_DATETIME

Similar to the DATE function, PARSE_DATE processes strings as input values. PARSE_DATETIME functions similarly but includes a time component along with the date.

PARSE_DATETIME(format_string, text)

PARSE_DATE(format_string, text)

Function 3: DATE_DIFF

This function is designed to compare two dates, making it invaluable during data analysis. It computes the difference in days, returning a positive result if the first date is later than the second.

DATE_DIFF(startTime, created)

Function 4: WEEK, WEEKDAY, MONTH, and EXTRACT

In contrast to the functions that create a DATE or DATETIME from strings or date parts, these functions allow for easy extraction of individual components, such as WEEKDAY, WEEK, and MONTH.

WEEKDAY(Date)

WEEK(Date)

YEAR(Date)

Alternatively, you can utilize EXTRACT to specify the desired date part as an input parameter.

EXTRACT(DAY FROM DATE(2022,02,02))

In this case, the output would be the number 2.

These fundamental features of Google Looker Studio can greatly enhance your data preparation and analysis efforts. For additional details, refer to the official Google documentation.

This video titled "Looker Studio Date Function Tutorial 2023" provides an in-depth explanation of how to effectively use date functions in Looker Studio.