# Date-only CRM activities land on the previous day

Because the CRM splits due date and time, parsing a bare date as midnight UTC lands it on the previous evening.

By Ki Moon · 2026-09-16 · finding · current
Canonical: https://kihmoon.com/bench-notes/p/date-only-activity-lands-a-day-early/

**Symptom:** Activities logged with a date but no time show on the day before in timelines viewed from the Americas. A reply also sorts below its own quoted copy.

CRMs often store an activity's due date and its time as separate fields, and the time is optional. Combining them into one timestamp is the standard move, and parsers such as JavaScript's Date read a bare date as midnight UTC.

Midnight UTC falls on the previous evening across the Americas, so a call logged for Tuesday with no time renders on Monday evening. Salesforce's Event object reference says ActivityDate holds the due date of an all-day event with a timestamp always set to midnight UTC, while ActivityDateTime holds the time for events that are not all-day.

Ordering breaks too. A date-only reply sorts below the quoted copy of it that arrived with a real time, so the thread reads backwards.

Date-only activities can be common enough to skew time-of-day metrics.

The remedy is to keep date and time separate, with a "time unknown" flag.

In a synthetic test set of 500 activities, 100 of them date-only, converting to Los Angeles time put all 100 on the previous day; keeping them as dates put none there. The set shows the mechanism, not how common it is.

## Check your setup (read-only)

Count CRM activities flagged as date-only. A date-only activity is a task's due date with no time, or an all-day event. Compare the date-only activities with the activities that carry an explicit time. Take the 10 most recent date-only activities. Find each one in your timeline and metric output. Any date-only activity shown with a time of day, or on the previous day, is a gap.

**Passes if:** Activities flagged as date-only show as date-only in your timelines and metrics. No date-only activity shows with a time of day or on the previous day.

**Access needed:** crm-read

## If it fails (changes to make later, not part of the check)

1. Store an activity's date and time separately, with a flag when the time is unknown.
2. Display a date-only activity as a date with no time zone shift, never as midnight UTC.
3. Rank an activity's own recorded time above any fallback time when sorting.
4. Count date-only activities per source before trusting any time-of-day metric.

**Applies if:** You back-fill email activity as CRM tasks, or build timelines and response-time metrics from tasks and events across time zones.

**Skip if:** Every activity you read carries a full timestamp with a time zone.

Tags: time, crm, data quality
