In HubSpot, date properties store specific moments in time, such as when a record was created or a deal closed. Properties such as “Create date” or “Last contacted” are static values that are recorded once and left unchanged. But there’s a limitation: HubSpot does not offer a native, always-updating “today” variable.
To work around this, you can create your own date property and populate it dynamically using workflows. When a workflow runs, you can insert the current system date into that field, creating a snapshot of “today” at that moment.
This method is helpful for workflows, reporting, and lifecycle tracking. It’s commonly applied to contact, deal, or company records to mark events such as qualification dates, outreach timing, or stage transitions.
At INSIDEA, we help operations teams configure this logic correctly so that automations trigger only when intended.
How It Works Under The Hood
HubSpot stores all date values as Unix timestamps. When a date is set in a property, HubSpot converts it to a time-based numerical format and displays it in your portal’s time zone.
To populate a property with the current date, you’ll use the Set property value action inside a workflow. In that action, you assign the value using the Date of step token. HubSpot captures the date when the workflow step runs and writes it into the selected property.
What You’ll Need:
- Custom property: Date picker type, for example, “Today’s Date”
- Workflow: Triggered by a condition or scheduled to run periodically
Once the workflow executes, the property captures the current date. The value does not update automatically. If you want the date to refresh daily, you must create a recurring workflow that rewrites the value each day.
Because HubSpot standardizes date formats at the backend, the stored value can be reused across filters, formulas, reports, and other workflows without compatibility issues.
Main Uses Inside HubSpot
Automating Date Stamps For Actions
Tracking when something happens is core to CRM operations. With a dynamic date property, teams can automate this without manual updates.
Example: When a contact meets MQL criteria, a workflow sets the MQL Date property to today. That timestamp becomes a dependable reference for lifecycle reporting and coordination between marketing and sales.
Measuring Time Since An Event
Sales managers often need visibility into how long it’s been since the last interaction. Using two date properties, such as Last Contacted Date and Today’s Date, you can calculate elapsed time.
With a calculated field or report, HubSpot can trigger alerts when too much time passes without engagement.
Example:
If Days Since Last Touch exceeds 14, a task is created or a notification is sent to the contact owner.
Tracking Subscription Or Contract Renewals
Customer success teams rely on accurate timing for renewals. Using today’s date as a reference makes it easy to calculate how close a renewal is or how overdue it has become.
Example workflow logic:
If Renewal Date minus Today’s Date is 30 days or less, trigger internal prep tasks or customer outreach automatically.
Common Setup Errors And Wrong Assumptions
Even small configuration errors can affect reporting. Watch out for these issues:
Mistake: Assuming “Today’s Date” updates automatically
Once set, the value stays fixed until another workflow overwrites it. Daily accuracy requires a daily workflow.
Mistake: Using the wrong property type
Date logic only works with Date picker properties. Text fields will not support date-based filters or calculations.
Mistake: Neglecting re-enrollment settings
If records cannot re-enroll, the date will never refresh after the first workflow run.
Mistake: Misunderstanding the “Date of Step” token
This token reflects when a workflow step runs, not when the record initially enrolled. Always test timing with sample records.
Step-By-Step Setup Or Use Guide
Follow these steps carefully to implement today’s date as a working CRM property:
- Create A Custom Date Property
Go to Settings > Properties > Create Property
Select the object (Contact, Deal, or Company)
Choose Date picker
Name it clearly, for example, “Today’s Date” - Build The Workflow
Go to Workflows > Create Workflow > Start from Scratch
Select the same object as the custom property - Define Enrollment Criteria
Use a test condition like “Contact is known” or your actual business trigger - Set The Current Date Automatically
Add Set property value
Select the custom date property
Choose Date of step as the value - Enable Re-Enrollment If Needed
Allow records to re-enroll if the date must refresh regularly - Run Tests
Use sample records
Check property history to confirm accurate values - Schedule Recurring Updates (Optional)
Create a scheduled workflow to overwrite the date daily if required - Apply The Property
Use it in filters, reports, workflows, or calculated properties
Measuring Results In HubSpot
After activation, monitor workflow and data performance to confirm value:
Key Metrics To Review:
- Workflow completion rate: Confirms records are being date-stamped
- Property fill rate: Shows how many records have a value
- Data freshness: Verifies daily or recurring updates run as expected
- Reporting impact: Confirms improvements in time-based metrics
Use the Workflow Performance tab and custom reports to validate record consistency.
Short Example That Ties It Together
A marketing ops lead wants visibility into stalled MQLs.
Steps taken:
- Create a Today’s Date property
- Run a daily workflow that refreshes the date
- Create an MQL Date property updated when scoring thresholds are met
- Build a report showing the difference between Today’s Date and MQL Date
- Trigger alerts when MQLs remain untouched for more than seven days
The result is automatic flagging of stalled leads and faster follow-up without manual review.
How INSIDEA Helps
HubSpot automation only works when the underlying logic is clean. INSIDEA helps teams implement reliable date-based workflows that support real reporting and operations.
Our Support Includes:
- Onboarding and setup: Build properties and workflows correctly from the start
- System management: Maintain clean data and stable automation
- Automation troubleshooting: Fix workflow logic for alerts, renewals, and tracking
- Reporting alignment: Connect business goals to metrics powered by accurate date values
If you want to hire HubSpot experts who can implement this logic properly and support it long-term, our HubSpot consulting services cover setup, cleanup, automation, and reporting support.
Capturing today’s date in HubSpot CRM properties clarifies workflows, reporting, and follow-ups. Set it up correctly, and use HubSpot consulting services to keep your automation reliable as operations grow.
