When you import list data to a property with the Date format, you can use custom date formatting to map the data to the model timescale.

The target list must have a list property with the Date format.

To map the timescale in a list import:

  1. In the Import dialog, in the Mapping tab, map a source column to a property with the Date format, and select the checkbox under Custom Date Mapping.
  2. In the Mapping dialog, choose a date pattern format.
    You can choose from:
      • Patterns with Separators
        For example, Y-M-D, where Y is the year (in one, two, or four digits), M is the month (in one or two digits or the month name), and D is the day number in the month.
        The separator can be any non-alphanumeric character.
      • Fixed-position Patterns
        For example, YYYYMMDD, where which digits refer to the year (YYYY), month (MM), and day (DD) is determined by the position in the source text.
      • Customer fixed-position pattern
        Enter a pattern to identify what each digit in the data signifies:
        • DD for a one or two digit calendar day between 1 and 31
        • WW for a one or two digit week number between 1 and 53
        • MM for a one or two digit month between 1 and 12
        • YY for a two-digit year (if you enter YYY, as in FYYY, the import looks for a valid two-digit number anywhere in the string)
        • YYYY for a four-digit year
        • MM for a one or two-digit month between 1 and 12
        • ? to represent any character to be ignored
  3. Optionally, select a different language in the Language for month names dropdown.
    If your data includes the names of months, the import should convert the names to numerals when you select the date pattern format. Select the language from the drop down that matches the data.
  4. Optionally, select the Use this format for all Date fields checkbox.
    If there's more than one property with the Date format, and you select this checkbox, the same date mapping automatically applies to the other property or properties as well.
  5. Select OK.

You can then either select Run Import, OK to save your import for later, or continue mapping the other columns.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.