Loading
CRM Analytics
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            Text to Date Transformation: Convert the Column Type

            You are here:

            1. Salesforce Help
            2. Docs
            3. CRM Analytics

            Text to Date Transformation: Convert the Column Type

            When you load data into a dataset, CRM Analytics tags a date column as a text (dimension) 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.

            Required Editions

            Text to Date Transformation: Convert the Column Type

            User Permissions Needed
            To create a recipe: Edit Analytics Dataflows OR Edit Dataset Recipes
            1. In the Transform node of a Data Prep recipe, select the text (dimension) column 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 showing options to specify the date format.
            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 change more column attributes, click the Column Attributes box, change them, and click Apply. The Column Attributes box showing the API Name, Output Type, and Date Format for a text column converted to a date column.
            7. Click Apply to add the transformation to the Transform node. The Preview tab shows the new date component column.
            8. To view the Graph area, click the Collapse button (Collapse button).
            9. Save the recipe.

            Run the recipe 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.

             
            Loading
            Salesforce Help | Article