Kommo Date Fields
This article describes working with Kommo date fields in LightLead.
Available Date Fields
Main date fields: lead_created_at (deal creation date), lead_closed_at (closing date). The date of the last update and the date of the nearest task are also available. All dates are in Unix timestamp format (seconds).
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 converts all dates to a single format.
Time Zones
Important aspects of working with 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 with time zone in mind
API: dates are returned in UTC via the API
Filtering by Date
Available date filtering types:
Exact date: a specific day
Date range: from a date to a 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