KeyCRM Date Fields
This article describes working with KeyCRM date fields in LightLead.
Available Date Fields
Date fields: created_at (order creation date), updated_at (last updated date). Dates are in ISO 8601 format. Product line items may additionally have a status-change 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 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