Happy Business Starts Here

Date Format of Service Period

New Student

Date Format of Service Period


Does anyone know how to change the date format to DD/MM/YYYY when surfacing the Service Date period on an invoice.  The invoice date is DD/MM/YYYY but Service Date Period is MM/DD/YYYY which as you can imagine is causing a few complaints from our UK customers.

Many thanks!


Re: Date Format of Service Period

@SharonS you can apply formatting in the Word merge field syntax:


{ MERGEFIELD Invoice.InvoiceDate \@ yyyy-MM-dd } as an example would give 2016-08-04


You can also use If conditions if you want to apply different formatting per country/region within the template. Our take on that was to standardize all our dates on the ISO 8601 format (https://en.wikipedia.org/wiki/ISO_8601) rather than try to show each country in, what they think should be, their native format.


Supporting (humorous) evidence: https://xkcd.com/1179/


Re: Date Format of Service Period

Also just noticed you said service period. If i recall correctly, this is an older string version of the date range. We opted to build the service period using two native date fields so we could format it to our liking. Those are: InvoiceItem.ServiceStartDate and InvoiceItem.ServiceEndDate


So our format was something like:


{ MERGEFIELD InvoiceItem.ServiceStartDate \@ yyyy-MM-dd }


{ MERGEFIELD InvoiceItem.ServiceEndDate \@ yyyy-MM-dd }