Help Center

In select BlueConic connections, you can use the Date conversion data processor to change your selected date field from one format to another. For instance, to ensure that in all date fields, the order is month/day/year.

Adding this data processor to your tenant

To use this data processor, you first need to add it to your tenant through the Plugins page (BlueConic Settings > Plugins). Click the Add plugin button at the top of this page and look for "Convert date to other date format" in the gallery. Then, click the Add plugin button underneath its description to install it.

Adding this data processor to a connection

The Date conversion data processor is available in all BlueConic connections that use data processors. You can review the complete list here.

Each of these connections has a specific step on its import and/or export goal page to add data processors (e.g., "Correct your files before the import," "Modify your data before the export"). In that step, use the search box to add "Convert date to other date format"; once added, it appears in a numbered list of data processors activated for that connection.

For more information, review the full article Using data processors with BlueConic connections.

Configuring this data processor

The Date conversion data processor requires some configuration to ensure that BlueConic imports or exports the data as specified. To make these configurations, click the cogwheel icon next to "Convert date to other date format" in the numbered list of data processors. This opens a window with the following settings:

• Column: Select the field that contains the date value(s) you want to convert.
• Current date format: Enter the date format that your date field currently uses.
• Target date format:  Enter the desired date format for your date field.

Sample scenarios for using this data processor

Review the following scenarios to see how you would set up the Date conversion data processor to clean up your data for optimal segmentation: