LP CRM Date Fields
This article describes working with LP CRM date fields in LightLead.
Available date fields
The main date field is lead_created_at (lead creation date). Additional dates may be available via custom fields. Date format: ISO 8601.
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 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: a sliding window (last N days from the current date)
Grouping by date
When grouping data by date, the following levels are available:
Year: 2026
Quarter: Q3 2026
Month: July 2026
Week: W30 2026
Day: 25.07.2026
Hour: 14:00