Data Studio is now Looker Studio. Looker Studio is still free, with the same features you already know. Looker Studio Pro offers improved asset management for enterprises, new team collaboration capabilities, and access to technical support. Learn more.

QUARTER

Returns the quarter of the year for a given date.

Sample usage

QUARTER(Date)

Syntax

1) Returns the quarter from a Date value.

QUARTER(date_expression)

2) Returns the quarter from a compatibility mode Date value.

QUARTER(X [,Input Format])

Parameters

  • datetime_expression - a Date & Time field or expression.
  • X - a field or expression that evaluates to Text, Number, or compatibility mode Date.
  • Input Format - format for X. Optional if X is correctly configured as a semantic date field.

Input format for compatibility mode dates

DAY accepts the following input formats if X is a Text field or expression, or compatibility mode Date:

  • Any valid strptime format is accepted.
  • 'BASIC': %Y/%m/%d-%H:%M:%S
  • 'DEFAULT_DASH': %Y-%m-%d [%H:%M:%S]
  • 'DEFAULT_SLASH': %Y/%m/%d [%H:%M:%S]
  • 'DEFAULT_DECIMAL': %Y%m%d [%H:%M:%S
  • 'RFC_1123': for example, Sat, 24 May 2008 20:09:47 GMT
  • 'RFC_3339': for example, 2008-05-24T20:09:47Z
  • 'DECIMAL_DATE': same as 'DEFAULT_DECIMAL'

DAY accepts the following input format if X is a Number field or expression:

  • 'SECONDS': seconds since Epoch
  • 'MILLIS': milliseconds since Epoch
  • 'MICROS': microseconds since Epoch
  • 'NANOS': nanoseconds since Epoch
  • 'JULIAN_DATE': days since Epoch

Examples

Formula Input Output
QUARTER(Date) Jan 1, 2019 1
QUARTER(Date as Text, 'BASIC') 2019/01/01-09:40:45 1
QUARTER(Date as Number, 'SECONDS') 1561784874 2

QUARTER(Date as lots of Numbers, 'MILLIS')

1562004058620 3

Notes

This function works with both compatibility mode dates and upgraded Date and Date & Time data types.

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
false
false
true
true
102097
false
false