Savant

<code>date</code>: The date for which you want to calculate the time period offset.

"day"/"week"/"month"/"quarter"/"year"/"decade": The time period to use for calculating the offset.

1. <code>date</code>: The date for which you want to calculate the time period offset.
2. "day"/"week"/"month"/"quarter"/"year"/"decade": The time period to use for calculating the offset.

TIME_PERIOD_OFFSET(`Event Date`, "quarter")

TIME_PERIOD_OFFSET(`Event Date`,"decade")

*Examples As of September 22, 2023

Calculates the number of time periods between a given date and the current period

TIME_PERIOD_OFFSET

Savant App

Savant Help

Find answers and get help from Intercom Support and Community Experts

Empty Help Center

Uh oh. That page doesn’t exist.

Disappointed

Neutral

Smiley

Title

Track the progress of all tickets related to your company.

Tickets portal.

{assigneeName} needs more information from you

Description	The `TIME_PERIOD_OFFSET()` function calculates and returns the number of time periods (e.g., day, week, month, quarter, year, decade) between a given date or datetime and the current period. This is useful for determining how far a date is from the current time period.
Syntax	TIME_PERIOD_OFFSET(`date`, "day"/"week"/"month"/"quarter"/"year"/"decade")
Output	integer

Event	Event Date	TIME_PERIOD_OFFSET(day)
Event A	September 10, 2023	−29
Event B	February 25, 2024	139
Event C	December 1, 2023	53
Event D	April 15, 2022	−542

Event	Event Date	TIME_PERIOD_OFFSET(week)
Event A	September 10, 2023	−5
Event B	February 25, 2024	19
Event C	December 1, 2023	7
Event D	April 15, 2022	−78

Event	Event Date	TIME_PERIOD_OFFSET(month)
Event A	September 10, 2023	−1
Event B	February 25, 2024	4
Event C	December 1, 2023	2
Event D	April 15, 2022	−18

Event	Event Date	TIME_PERIOD_OFFSET(quarter)
Event A	September 10, 2023	−1
Event B	February 25, 2024	1
Event C	December 1, 2023	0
Event D	April 15, 2022	−6

Variables

Example 1

Example 2

Example 3

Example 4

Example 5

Example 6

Event	Event Date	TIME_PERIOD_OFFSET(year)
Event A	September 10, 2023	0
Event B	February 25, 2024	1
Event C	December 1, 2023	0
Event D	April 15, 2022	−1

Event	Event Date	TIME_PERIOD_OFFSET(decade)
Event A	September 10, 2023	0
Event B	February 25, 2024	0
Event C	December 1, 2023	0
Event D	April 15, 2022	0