Configuring to Support DMY and YMD Date Formats

This topic describes how to configure your environment to support Date Month Year (DMY) and Year Month Day (YMD) Date formats. The examples in this topic address the process for configuring an Aptify environment to use the date format used in Australia (DMY).

1. Set server Region & language setting to required culture.

1. Set Server SQL Default language to British English

Open SQL server Right click on SQL server ->Advance -> Default Language -> Select British English
SOA Pool User Default Language can be English or British English.

1. Download or create different Kendo cultural files for the desired culture in the *C:\inetpub\wwwroot\Aptify\script* folder. You can find cultural files at the following URLs:

• http://cdnjs.com/libraries/kendo-ui-core
• https://code.google.com/p/concerto-platform/source/browse/v4/cms/js/lib/kendo-ui/js/cultures/ 

For example, the kendo.culture.en-AU.min.js file is used for an Australian environment

1. Open C:\inetpub\wwwroot\Aptify\script\Aptify\framework\ Aptify.Framework.Bootloader.js file for editing.
2. Search for the getThirdPartyResourcelist() function and add the name of the Kendo culture file to the list of files for the results variable.

For example
function getThirdPartyResourcelist() {
var results;
results = [
//"/log4javascript/log4javascript.js",
"/jquery-1.10.2.min.js",
"/kendo.all.min.js",
"/jquery.Jcrop.min.js",
"/knockout-2.2.1.js",
"/adapter.js",
"/jquery.signalR-2.0.2.min.js",
"/Ace/src-min-noconflict/ace.js",
"/Ace/src-min-noconflict/ext-language_tools.js",
"/dom.jsPlumb-1.7.2.1-min.js",
"/jszip.js",
"/kendo.culture.en-AU.min.js"
];
return Aptify.framework.bootloader.getAbsolutePathForAptifyThirdParty(results);
}

1. Save and close the Aptify.Framework.Bootloader.js file.
2. Open the Aptify.Framework.Configuration.External.js file for edting.
3. Add following values based on the required culture. Aptify.framework.configuration.cultureName =" <culture>" Aptify.framework.configuration.calendarDateHeaderFormat = "<date format>";

The following values would be used for an Australian environment: Aptify.framework.configuration.cultureName = "en-AU"; Aptify.framework.configuration.calendarDateHeaderFormat = "ddd dd/MM";

1. Save and close the Aptify.Framework.Configuration.External.js file
2. Open the Aptify.Framework-5.5.5.min.js file for editing.
3. Find the shortDateFormat and longDateFormat settings and update the date and time format to the format required for the desired culture. The following values would be used for an Australian environment. Aptify.framework.configuration.shortDateFormat = "d/MM/yyyy"; Aptify.framework.configuration.longDateFormat = "d/MM/yyyy h:mm:ss tt";

1. In the Aptify Desktop client, open the Cultures record for the desired culture.

1. Click the Culture Formats tab and update the DateFormat and DateTimeFormat settings to align with the shortDateFormat and longDateFormat values used in the previous step.

1. Ensure that the web users in Aptify are configured to use the desired culture.