Skip to main content
Skip table of contents

Dates

With Backbone, you can synchronize custom Date and Date Time fields in a number of different configurations.

  • Date field
    • to Date field: the date information will be synced to a date field.
    • to Date Time field: the date information will be synced to a date and time field – the time will be set as 12:00 AM (00:00).
    • to Text field: the date information will be synced to a text field in a specified format.
  • Date Time field
    • to Date Time field: the date and time information will be synced to a Date Time field.
    • to Date field: the date information will be synced into a date field, and the time information will be removed.
    • to Text field: the date and time information will be synced into a text field in a specified format.

Date and Date Time to Text field mappings

The Date and Date Time formats can be defined in the Date format box on the Create Field Mapping screen:

Examples of some possible date/time formats (these are just examples, the format can be modified in many ways):

PatternOutput
EEE dd-MMMM-yyyyMon 19-December-2016
yy-MMMM-dd hh:mm:ss16-December-19 12:00:00
yy-MM-dd'T'hh:mm:ss16-12-19'T'12:33:45
yy-MM-dd hh:mm:ss16-12-19 12:33:45
yy-MM-EEE'T'hh:mm:ss16-12-Mon'T'12:33:45
yy-MM-EEE hh:mm:ss16-12-Mon 12:33:45

It's also possible to replace : and - and T with other symbols/strings, for example:

PatternOutput
yyyy.MMMM.dd 'Time:' hh:mm:ss 2016.December.19 Time: 12:00:00
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.