---
title: "Relative date and time"
slug: "relative-selects"
description: "Learn how to configure relative date and time selections in Zilliant CPQ."
updated: 2024-11-01T19:59:56Z
published: 2024-11-01T19:59:56Z
canonical: "docs.zilliant.com/relative-selects"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.zilliant.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Relative date and time

## Configure relative date and time

You can create search queries based on date and time, or on specific users. For example, you can define search queries such as **Last Two Quarters**, **Next Quarter**, or **Users in My Organization**.

#### Relative date and time selections

Use a predefined relative date and time selection when searching for specific objects. These include:

- 90 Days from today
- First day of last month
- First day of last quarter
- First day of last year
- First day of next month
- First day of next quarter
- First day of next year
- First day of this month
- First day of this quarter
- First day of this year
- Last day of next month
- Last day of next quarter
- Last day of next year
- Last year, first day of next month
- Last year, first day of next quarter
- Last year, first day of this month
- Last year, first day of this quarter
- Last year, today’s date
- Today's date

          Note

          

There is only one relative time select: **Now**. You cannot create new time selections.

## Create relative date queries

Administrators can create custom relative date queries to meet specific business requirements. To do this, perform the following steps:

1. From the application left navigation area, select **Administration**.
2. From **Master Data Management**, select **Relative Selects**.
3. Select ![](https://cdn.document360.io/24f960e8-3c1c-4c18-a2c6-83b6ae4aab84/Images/Documentation/CPQ-icon_add.png?sv=2026-02-06&spr=https&st=2026-11-11T12%3A06%3A50Z&se=2026-11-11T13%3A06%3A50Z&sr=c&sp=r&sig=DfHzqxOzZeHHm7xX6%2FqyN%2FVC2r%2FcwBRpsNR6kOqF7Nc%3D) to add a row to the list.
4. Select the newly created item, and in the **Configuration** tab:
  - **Name**—Enter a name.
  - **Type**—Choose the unit, such as days, weeks, months, quarters, or years.
  - **Offset**—Indicates when the resulting date should be:
    - An offset of zero indicates today's date
    - A negative offset indicates a date in the past
    - A positive offset indicates a date in the future
  - **Day of the Month**—(Optional.) Enter the appropriate value.
5. Select **Save**.

In the **Resulting Filtering Date**, verify the search you have configured. For example, if today is May 7, and you have defined **Type=Month** with an offset of **1**, the resulting date should be June 7.

#### Relative user selections

Use predefined, relative user selections such as:

- Me / Current Logged-In User
- Users in My Organization Unit
- Users in my Organization Hierarchy

          Note

          

You cannot add a custom relative user select query.