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):
Pattern |
Output |
---|---|
EEE dd-MMMM-yyyy |
Mon 19-December-2016 |
yy-MMMM-dd hh:mm:ss |
16-December-19 12:00:00 |
yy-MM-dd'T'hh:mm:ss |
16-12-19'T'12:33:45 |
yy-MM-dd hh:mm:ss |
16-12-19 12:33:45 |
yy-MM-EEE'T'hh:mm:ss |
16-12-Mon'T'12:33:45 |
yy-MM-EEE hh:mm:ss |
16-12-Mon 12:33:45 |
It's also possible to replace : and - and T with other symbols/strings, for example:
Pattern |
Output |
---|---|
yyyy.MMMM.dd 'Time:' hh:mm:ss |
2016.December.19 Time: 12:00:00 |