HubSpot date fields
This article describes working with HubSpot date fields in LightLead.
Available date fields
Main date fields: createdate (created), closedate (closed), hs_lastmodifieddate (last modified). Dates are in ISO 8601 format. Additional dates are available via custom properties of type date.
Date format
Dates are stored and processed in the following formats:
| Format | Description | Example |
|---|---|---|
| ISO 8601 | International standard | 2026-07-25T14:30:00Z |
| Unix timestamp | Seconds since 01.01.1970 | 1752019800 |
| Date only | Date only, no time | 2026-07-25 |
When building reports, LightLead automatically normalizes all dates to a single format.
Time zones
Important considerations for time zones:
Storage: dates are stored in UTC
Display: dates are shown in the interface using the LightLead account's time zone
Filtering: date filters are applied accounting for the time zone
API: dates are returned via the API in UTC
Filtering by date
Available date filtering types:
Exact date: a specific day
Date range: from date to date
Relative periods: today, yesterday, last 7/30/90 days, this/last month, this/last year
Dynamic periods: rolling window (last N days from the current date)
Grouping by date
The following levels are available when grouping data by date:
Year: 2026
Quarter: Q3 2026
Month: July 2026
Week: W30 2026
Day: 07/25/2026
Hour: 14:00