HighLevel Date Fields
This article describes working with HighLevel date fields in LightLead.
Available Date Fields
Main date fields: createdAt (creation), updatedAt (update), closedAt (closing). Dates are in ISO 8601 format. Additional dates are available through custom fields.
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 without time | 2026-07-25 |
When building reports, LightLead automatically normalizes all dates to a single format.
Time Zones
Important aspects of working with time zones:
Storage: dates are stored in UTC
Display: in the interface, dates are shown in the LightLead account's time zone
Filtering: date filters are applied with the time zone taken into account
API: dates are returned in UTC through the API
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: 25.07.2026
Hour: 14:00