---
schema_version: "1"
id: 7cde2f6b425bafb296b7b845cbd6454604f0d300062830ecadf3b3aa71993b95
title: MDP Date Values in LiteConnect Data Streams
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_data_streams_lite_create_dates.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_data_streams_lite_create_dates.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 32d7a8c843b0dcf4e69269f9de449840b636dcdf4974958c7c90a778f12ce9a4
description: A LiteConnect data stream has two date columns. The date changes according to the source data.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# MDP Date Values in LiteConnect Data Streams

A LiteConnect data stream has two date columns. The date changes according to the source data.

![LiteConnect date columns example](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mcidp-264-0-0-production-enus/6ea21a7c-b623-43b5-9bb1-3174d8e8301e/mcidp/images/data_lite_date_columns.png)

The DAY column (1) contains the date value as interpreted by Marketing Cloud Intelligence Data Pipelines. You can’t edit this column. The DATE column (2) is the actual date column that comes from the source file. MDP automatically assigns the DAY value to the first date column that it finds in the source file.

If the source file has more than one date column, select a different date to go by instead of the one that MDP selected.

If the uploaded source file doesn’t have a date column but has measurements, the Yesterday day value is automatically assigned. A measurement must have a date.

![LiteConnect showing default date](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mcidp-264-0-0-production-enus/6ea21a7c-b623-43b5-9bb1-3174d8e8301e/mcidp/images/data_lite_default_date.png)

If the uploaded file contains only dimensions, the day value is empty because it isn’t required.

![LiteConnect showing void dates](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mcidp-264-0-0-production-enus/6ea21a7c-b623-43b5-9bb1-3174d8e8301e/mcidp/images/data_lite_void_date.png)