examples of date and numeric formatting
to combine fields in date formats, yyyy and yyyy can be different for the same date or timestamp. yyyy represents the calendar year of the date while yyyy represents the year of the week.
for example, the calendar year of the date 2020-12-28 is 2020; on the other hand, the date is Monday, the first day and first week of the year 2021. for the date, the year of the week is 2021. if you use yyyy as the date format, the year displayed for 2020-12-28 is 2020 If you use yyyy as the date format, the year displayed for 2020-12-28 is 2021.
Therefore, it is recommended to always use the yyyy format for date merge fields.
The following table includes formatting examples for date and number type mail merge fields.
to use the standard date format: 10/26/2012
{combined field invoice.invoice date}
to use simple date format: 20121026
to use text date format: Oct 2012
to use the standard percentage format: 0.08
to use the percent symbol format: 8%
to specify a label for a quantity: 3.0000 kg
to specify a symbol for a currency: €12.13.8