Considerations for Date Columns

Confirm that date values in a column are uniform in format and time zone. Inconsistencies can occur within a data source and after merging data from multiple data sources.

Perform the following tasks for date columns.

• Ensure consistent date formats. When combining data from different data sources, sometimes dates are stored in different formats, such as MM-dd-yyyy and yy-MM-dd’T’HH:mm:ss’Z’. Use the Format Date transformation to make the formats consistent.
• Fix time zone differences in datetime columns. CRM Analytics doesn’t officially support multiple time zones. If a column contains a mix of time zones, consider creating a calculated column with the Formula transformation to add or subtract hours to datetime values to ensure a single time zone.

Note All date column labels in a dataset must be unique.