Configuring a Date Attribute

How to configure date attributes in Plytix using standard formatting rules when importing and exporting

Dates are often written differently depending on region or personal preference. This article lists the format rules, explains how to configure your date attribute format for import, and explains how to configure the date attribute when sharing data.

 

ℹ️  In Plytix, all date attributes are displayed as [Month Abbreviation (Day), Year] (Ex: Nov 14, 2022) by default and can only be modified upon export.

 

Date Format Tokens

Configuring the Date Format for Import

Configuring the Date Format for Export

 

*Skip to any section in this article by clicking on the links above

 


Date Format Tokens

Below is the list of tokens you can choose from when configuring a date attribute: 

 

Configuring Date-1

 

For Example:
Date column in CSV Format Tokens
25.12.2020 %d.%m.%Y 
12/25/2020 %m/%d/%Y

25-Dec-2020

%d-%b-%Y

 


Configuring the Date Format for Import

When importing a CSV with a date attribute, you must define how Plytix should read that date.

To import a date attribute:

  1. Follow the steps to import product data

  2. During the matching process, match the date to an existing date attribute or create a new date attribute

  3. You will see these settings: 

Configuring the date format when importing product data

 

4. In the "Date Format" field, type in the corresponding tokens to identify how the date is shown in your CSV file and how Plytix should read it. Separate the tokens using the same spacing character as in your CSV file (typically: - or . or / )

 


Configuring the Date Format for Export

Formatting the date attribute for output follows a similar process for Product Sheets, Brand Portals, and Channels. 

  1. Follow the steps to creating or managing a Product Sheet, Brand Portal, or Channel and add the Date attribute you want to show. 
  2. In the 'Attributes' tab find your date attribute.
  3. In the 'Formatting' column, you can see the current output format.
  4. Click on the 'Settings' icon that appears when you hover your mouse over the date attribute.date-format
  5. Type in the new format tokens.In the settings area, you can change the token to reformat the date.
  6. Click 'Okay' and 'Save Changes' on your product sheet, brand portal or channel.

 


What's next? 

 

If you have any questions just click on the chat box in the bottom-right corner and we'll be happy to answer them...

 

and please let us know 👇