In select BlueConic connections, you can use the Date format 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 "Date format conversion" in the gallery. Then, click the Add plugin button underneath its description to install it.
Adding this data processor to a connection
The Date format 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 "Date format conversion"; 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 format 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 "Date format conversion" in the numbered list of data processors. This opens a window with the following settings:
- Date field: 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.
Example date formats
Some examples of date formats that can be used with this processor include:
- M/DD/YY = 3/14/24
- MM/DD/YYYY = 03/14/2024
- YYYYMMDD = 20240314
- DD-MMM-YY = 14-Mar-24
- MMMM D, YYYY = March 14, 2024
- M/D/YY h:mm A = 3/14/24 1:30 PM
- DD-MM-YYYY HH:mm:ss = 14-03-2024 02:30:05
- YYYY-MM-DD h:mm:ss = 2024-03-14 2:30:05
- MM/DD/YYYY HH:mm:ss = 03/14/2024 02:30:05
Sample scenarios for using this data processor
Review the following scenarios to see how you would set up the Date format conversion data processor to clean up your data for optimal segmentation:
| Settings | Mappings (original and new values) |
|
Date field: Last visited date Current date format: YYYY-MM-DDTHH:mm:ss Target date format: DD-MMM-YY |
Original value: 2022-01-12T01:05:55 New value: 01-Dec-22 |
|
Date field: Today's date Current date format: M/DD/YY Target date format: YYYY-MM-DD |
Original value: 2/01/23 New value: 2023-02-01 |
|
Date field: Today's date Current date format: MM/DD/YYYY Target date format: YYYY-MM-DD |
Original value: todays_date New value: Value is removed |