Data is imported and stored in WordFly through data fields. These can be set up in different formats: text, number, and date data fields. Number and date data fields require importing specific formats to work with the formatting WordFly applies to the data field in your email. In this article we will review what you should know for your number and date data fields.
Number data fields
Number data fields can be created to personalize emails with specific number or currency data from your subscriber list.
Number formats available in WordFly
When you create a new number format data field in WordFly you will have many options to select from. Go to Subscribers > Data Fields, select Create a custom field, then select Format > Number.
Example of number formats available
List format guidelines for number data
In order for WordFly to translate the number data from your list to the data field format selected in WordFly you will need to make sure your list format does not have any specific formatting. Applying specific formatting in your list will conflict with the formatting WordFly applies through the data field format you select.
Decimals are acceptable but adding a currency symbol for example will cause conflicts with WordFly formatting that data field.
If you would rather use your list format then use a text format data field instead since text data fields in WordFly don't apply any formatting to your data.
Date data fields
Date data fields can be created to personalize emails with specific date information from your subscriber list.
Date formats available in WordFly
When you create a new date format data field in WordFly you will have many options to select from. Go to Subscribers > Data Fields, select Create a custom field, then select Format > Date.
Example of date formats
List format guidelines for date data
In order for WordFly to translate the date data from your list to the data field format selected in WordFly you will need to make sure your list format does not have any specific formatting. Applying specific formatting in your list will conflict with the formatting WordFly applies through the data field format you select.
If you would rather use your list format, then use a text format data field instead since text data fields in WordFly don’t apply any formatting to your data.
Acceptable date formats for your list
These examples are for accounts in the USA with a culture setting of en-US. If your account uses a CRM integration, such as Tessitura or Centaman, you dates should be provided in the format that matches the SQL server culture setting where WordFly services are installed.
M/d/yyyy M/d/yy MM/dd/yy MM/dd/yyyy yy/MM/dd yyyy-MM-dd dd-MMM-yy dddd, MMMM dd, yyyy MMMM dd, yyyy dddd, dd MMMM, yyyy dd MMMM, yyyy dddd, MMMM dd, yyyy h:mm tt dddd, MMMM dd, yyyy hh:mm tt dddd, MMMM dd, yyyy H:mm dddd, MMMM dd, yyyy HH:mm MMMM dd, yyyy h:mm tt MMMM dd, yyyy hh:mm tt MMMM dd, yyyy H:mm MMMM dd, yyyy HH:mm dddd, dd MMMM, yyyy h:mm tt dddd, dd MMMM, yyyy hh:mm tt dddd, dd MMMM, yyyy H:mm dddd, dd MMMM, yyyy HH:mm dd MMMM, yyyy h:mm tt dd MMMM, yyyy hh:mm tt dd MMMM, yyyy H:mm dd MMMM, yyyy HH:mm dddd, MMMM dd, yyyy h:mm:ss tt dddd, MMMM dd, yyyy hh:mm:ss tt dddd, MMMM dd, yyyy H:mm:ss dddd, MMMM dd, yyyy HH:mm:ss MMMM dd, yyyy h:mm:ss tt MMMM dd, yyyy hh:mm:ss tt MMMM dd, yyyy H:mm:ss MMMM dd, yyyy HH:mm:ss dddd, dd MMMM, yyyy h:mm:ss tt dddd, dd MMMM, yyyy hh:mm:ss tt dddd, dd MMMM, yyyy H:mm:ss dddd, dd MMMM, yyyy HH:mm:ss dd MMMM, yyyy h:mm:ss tt dd MMMM, yyyy hh:mm:ss tt dd MMMM, yyyy H:mm:ss dd MMMM, yyyy HH:mm:ss M/d/yyyy h:mm tt M/d/yyyy hh:mm tt M/d/yyyy H:mm M/d/yyyy HH:mm M/d/yy h:mm tt M/d/yy hh:mm tt M/d/yy H:mm M/d/yy HH:mm MM/dd/yy h:mm tt MM/dd/yy hh:mm tt MM/dd/yy H:mm MM/dd/yy HH:mm MM/dd/yyyy h:mm tt MM/dd/yyyy hh:mm tt MM/dd/yyyy H:mm MM/dd/yyyy HH:mm yy/MM/dd h:mm tt yy/MM/dd hh:mm tt yy/MM/dd H:mm yy/MM/dd HH:mm yyyy-MM-dd h:mm tt yyyy-MM-dd hh:mm tt yyyy-MM-dd H:mm yyyy-MM-dd HH:mm dd-MMM-yy h:mm tt dd-MMM-yy hh:mm tt dd-MMM-yy H:mm dd-MMM-yy HH:mm M/d/yyyy h:mm:ss tt M/d/yyyy hh:mm:ss tt M/d/yyyy H:mm:ss M/d/yyyy HH:mm:ss M/d/yy h:mm:ss tt M/d/yy hh:mm:ss tt M/d/yy H:mm:ss M/d/yy HH:mm:ss MM/dd/yy h:mm:ss tt MM/dd/yy hh:mm:ss tt MM/dd/yy H:mm:ss MM/dd/yy HH:mm:ss MM/dd/yyyy h:mm:ss tt MM/dd/yyyy hh:mm:ss tt MM/dd/yyyy H:mm:ss MM/dd/yyyy HH:mm:ss yy/MM/dd h:mm:ss tt yy/MM/dd hh:mm:ss tt yy/MM/dd H:mm:ss yy/MM/dd HH:mm:ss yyyy-MM-dd h:mm:ss tt yyyy-MM-dd hh:mm:ss tt yyyy-MM-dd H:mm:ss yyyy-MM-dd HH:mm:ss dd-MMM-yy h:mm:ss tt dd-MMM-yy hh:mm:ss tt dd-MMM-yy H:mm:ss dd-MMM-yy HH:mm:ss MMMM dd MMMM dd yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK yyyy'-'MM'-'dd'T'HH':'mm':'ss.fffffffK ddd, dd MMM yyyy HH':'mm':'ss 'GMT' ddd, dd MMM yyyy HH':'mm':'ss 'GMT' yyyy'-'MM'-'dd'T'HH':'mm':'ss h:mm tt hh:mm tt H:mm HH:mm h:mm:ss tt hh:mm:ss tt H:mm:ss HH:mm:ss yyyy'-'MM'-'dd HH':'mm':'ss'Z' dddd, MMMM dd, yyyy h:mm:ss tt dddd, MMMM dd, yyyy hh:mm:ss tt dddd, MMMM dd, yyyy H:mm:ss dddd, MMMM dd, yyyy HH:mm:ss MMMM dd, yyyy h:mm:ss tt MMMM dd, yyyy hh:mm:ss tt MMMM dd, yyyy H:mm:ss MMMM dd, yyyy HH:mm:ss dddd, dd MMMM, yyyy h:mm:ss tt dddd, dd MMMM, yyyy hh:mm:ss tt dddd, dd MMMM, yyyy H:mm:ss dddd, dd MMMM, yyyy HH:mm:ss dd MMMM, yyyy h:mm:ss tt dd MMMM, yyyy hh:mm:ss tt dd MMMM, yyyy H:mm:ss dd MMMM, yyyy HH:mm:ss MMMM, yyyy