---
schema_version: "1"
id: 660c29d500d656e932f18d7962db3ad35caeaddc174707388741ec657b698663
title: "Text to Date Transformation: Convert the Column Type"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_transformation_dimensiontodate.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_transformation_dimensiontodate.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: bc2a342105d4e7096a47546ee480db0f20f3fc5f445c91b39a74c7510bc1a235
description: A date column is sometimes tagged as text if it contains unexpected string values or dates in different formats. To use date functionality, such as grouping by month, use the Text To Date transformation to change the Text column type to Date.
products:
  - Data 360
release: "264"
---
# Text to Date Transformation: Convert the Column Type

A date column is sometimes tagged as text if it contains unexpected string values or dates in different formats. To use date functionality, such as grouping by month, use the Text To Date transformation to change the Text column type to Date.

1. In the Transform node, select the text column that you want to convert to the Date column type. For example, you standardized the dates in a text column and now want to convert the column type to Date.
2. In the Transform toolbar, select **Text to** | **Date**.
    
    ![The To Date modal provides options to specify the date format.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_integrate_dim2date_settings.png)
3. In the Date Format field, select the date format to display the dates.
4. Under Show Results In, select whether the new values appear in a new column and whether to keep the original column.
5. If you elect to create a column, set the label under Column Label.
6. To add the transformation to the Transform node, click **Apply**. The Preview tab shows the new date component column.
7. To view the canvas area, click the **Collapse** button (![Collapse button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-data-data_cloud-264-0-0-production-enus/f3569962-3c9b-4f83-9d0c-b6a574e785da/resources-global/analytics/images/bi_button_collapse.png)).

Run the data transform to convert the column type to Date and the date values to the specified format. If the transformation can’t parse a date value, it replaces the value with null.