Skip to content

Use today's date in the CRM

Last updated: October 16, 2025

Available with any of the following subscriptions, except where noted:

To track data compared to the current day, you can use today's date and other relative measures of time in your CRM. For example, if you create a Renewal date property, you can set the property to display time from today (e.g., Renewal date is 10/28/2024, 12 days from today) and filter records based on their Renewal date values (e.g., Renewal date is this month).

In this article, learn more about the ways you can use today's date and relative time in HubSpot:

Display property values with relative time from today

For date picker and date and time picker properties, you can choose to display their values including the number of days from the current date. This option is available for both default and custom properties. 

  1. In your HubSpot account, click the settings settings icon in the top navigation bar.
  2. In the left sidebar menu, navigate to Properties
  3. Create a property or edit an existing property
  4. Navigate to the Field Type tab. The field type must be either Date picker or Date and time picker.
  5. Select Show [date/date and time] with relative time. Displaying relative time doesn't affect the property's values.
  6. Finishing setting up or editing the property, then click Create or Save.

When viewing the property value on a record, the number of days ago or from today will be displayed. 

A HubSpot All Properties panel for Mozzie. The highlighted Create date property shows the value 07/15/2025 10:28 AM EDT (3.1 months ago).

Please note: relative time is not supported when viewing the property's values in forms, reports, or the mobile app.

Use today's date or relative time in filters

You can set up filters based on today's date or relative time from today in HubSpot tools to segment records, trigger automation, and report on data. Below are the supported tools and example use cases.

If you've created Time since or Time until calculation properties (Professional and Enterprise only) and want to filter by those instead, learn how to use the properties.

Object index pages

When filtering records on an object index page, you can set criteria for date and date and time properties using relative time measures. This includes default options such as Today or Last quarter, and custom measures such as more than 10 days ago or less than 45 days from now.

For example, to view deals with a Close date value of today:

  1. In your HubSpot account, navigate to CRM > Deals.
  2. Above the table, click the Close date dropdown menu and select Today. You can also click Advanced filters to use other date properties. Learn more about advanced filtering.
  3. Click the saveEditableViewIcon save icon to save your filter changes.

A HubSpot deals index page with 273 records. A search dropdown is open, showing the filter option Today, allowing the user to search for deals created today.

For example, to view contacts with a Create date of more than 14 days ago:
  1. In your HubSpot account, navigate to CRM > Contacts.
  2. Click Advanced filters.
  3. In the right panel:
    • Click Add filter.
    • Select Create date.
    • Click the operator dropdown menu and select is more than.
    • In the text field enter 14.
    • Click the X.
  4. Click the saveEditableViewIcon save icon to save your filter changes.
GIF displaying a contact index page. The user adds a filter in the right panel to be 'create date is more than 14 days ago'.

Learn more about filtering records.

Segments

When filtering records to include in a segment, you can set criteria for date and date and time properties using the relative time from today. For example, Last activity date is more than 10 days ago or Close date is less than 45 days from now. You can also filter based on how recently a value was updated or if a value is before or after another property's value.

For example, to create a segment include contacts who engaged with your team today:

  1. In your HubSpot account, navigate to CRM > Segments.
  2. Create a segment or edit an existing active segment.
  3. In the left panel, click + Add filter. Set your segment criteria using relative time from today with [Object] properties as the filter category.
  4. Select Contact properties > Last engagement date > is > today.
  5. Continue setting up or editing your segment, then click Save segment.

GIF displaying contact segment configuration. The user selects last engagement date property is today.

For example, to create a segment based on deals closing within seven days from now:

  1. In your HubSpot account, navigate to CRM > Segments.
  2. Create a segment or edit an existing active segment.
  3. In the left panel, click + Add filter. Set your segment criteria using relative time from today with [Object] properties as the filter category.
  4. Select Deal properties > Close date > is less than > 7 > days from now.
  5. Continue setting up or editing your segment, then click Save segment.

GIF displaying deal segment configuration. The user selects close date is less than 7 days from now.

Learn more about how to create segments and determine your segment criteria.

Reports

Subscription required A Professional or Enterprise subscription is required to the custom report builder.

When creating or editing a report, you can set date ranges and filters based on today's date and relative time. This applies to default reports from the report library or custom reports created in the custom report builder.

Single-object reports

  1. In your HubSpot account, navigate to Reporting > Reports.
  2. Click Create report or edit an existing report.
  3. Select single-object report.
  4. Click Next.
  5. Select your data source.
  6. Click Next.
  7. Configure your report. You can select date filters at the top (e.g., Create date is this quarter so far).
  8. When you're finished, click Next.

A HubSpot report builder screen with the Data tab selected. Two red arrows point to the Create Date and This quarter so far filters, showing a record created on 10/15/2025.

Custom reports

  1. In your HubSpot account, navigate to Reporting > Reports.
  2. Click Create report or edit an existing report.
  3. Select Custom report.
  4. In the upper right, click Next.
  5. Select your data sources.
  6. Click Next.
  7. Configure your report. You can select default options or set custom relative time measures for when filtering date/date and time fields (e.g., .
  8. When you're finished, click Save report.

GIF displaying a custom contacts report with the unique count of contacts. The user adds 2 date filters for create date between this quarter and last quarter.

Workflows

Subscription required A Professional or Enterprise subscription is required to use workflows.

You can use today's date or other relative time measures in workflow enrollment triggers and branches. For example, create a workflow that sends you a notification when a deal's Close Date is today.

  1. In your HubSpot account, navigate to Automation > Workflows.
  2. Click Create workflow.
  3. Add an enrollment trigger or branch.
  4. Select [Object] properties as the filter category.
  5. Select a date/date and time property.
  6. To set criteria based on today's date, use the is, less than, or more than operators to specify the current date or the number of days from the current date. In the example below, if the workflow runs every day, a deal will be enrolled in the workflow if its Close date is the current date.
  7. Click Save.
  8. Add actions as needed. For example, you could send a notification to the deal owner when the Close date is today.
  9. Publish and turn on the workflow.

Datasets

Subscription required A Data Hub Enterprise subscription is required to use datasets.

In datasets, you can use date/date and time properties and date functions in filters and formulas to calculate relative time. Learn more about creating custom datasets.

For example:

  • To calculate the time until a contact's birthday, use DATEDIFF("DAY",[Birthday], NOW()).
  • To show deals whose Last activity date value is more than 30 days from today's date, you could use IF(DATEDIFF("DAY",[Deal Last activity date], NOW()) > 30, " More than 30", "Less than 30").

A HubSpot dataset editor. The highlighted formula calculates if the difference between the Deal last activity date and NOW() is greater than 30 days.

 

Use time since and time until calculation properties

Subscription required A Professional or Enterprise subscription is required to use calculation properties and workflows.

You can create calculation properties that track the amount of time since or until a date. For example, you can create a Time since open property to track how long a deal has been open in your pipeline. Learn how to create time since and time until calculation properties.

You can also filter records by the properties on object index pages or in segments, workflows, and single-object reports. Time since and time until properties can be used with the following operators:

  • is less than
  • is greater than
  • is known
  • is unknown

For example, you can enroll deals in a workflow if their Time since open property is greater than 30 days to assign a task to the appropriate member of your sales team.

  1. In your HubSpot account, navigate to Automation > Workflows.
  2. Create a workflow.
  3. Click Met filter criteria.
  4. Select Deal.
  5.  Select Deal properties.
  6. Click your custom Time since open property. 
  7. Click the operator dropdown menu and select is greater than.
  8. In the text field enter 30.
  9. Click Next.
  10. Click Save and continue.
  11. In the left panel, in the Browse all actions text field, enter task.
  12. Click Create task and configure information such as name, assignee, and due date.
  13. When you're finished, click Save.
  14. In the upper right, click Review and publish.

GIF displaying a deal-based workflow setup. The user configures a time since open property as the trigger and a task action for the owner of the deal.

Please note: time since and time until properties are not supported in the following:

Was this article helpful?
This form is used for documentation feedback only. Learn how to get help with HubSpot.