Returns the week number for a given date.

Sample usage

WEEK(Hit time)


WEEK(X [,Input Format])


  • X - a field or expression that evaluates to text, number, or date.
  • Input Format - format for X. Optional if X is correctly configured as a semantic date field.

Input format

WEEK accepts the following input formats if X is a text field.

  • 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

WEEK accepts the following input format if X is a numerical field.

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


Formula Input Output
WEEK(Hit time) Jan 1, 2019 1
WEEK(Hit time, 'BASIC') 2019/01/01-09:40:45 1
WEEK(Hit time, 'SECONDS') 1561784874 26
WEEK(Hit time, 'MILLIS') 1562004058620 27

Related resources

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue