Migrating Date Format

Owned by Ravikumar Babu CTOO (Unlicensed)
Last updated: Sept 10, 2019


The information on this page is for implementation teams who are using the old version of Canvas Technology platform, i.e. 14.1 version or lower. For 14.1 or older versions of Canvas Technology, the DATEMASTER table was used for the Date format configuration. The DATEMASTER table is deprecated from Canvas Technology 15.1 onwards.

DATEMASTER
DATE_IDDATE_FORMAT
D004MM/dd/yyyy
D003dd/MM/yyyy
D013dd-MM-yyyy
D002MM-dd-yyyy

In Canvas Technology 14.1 and lower versions, the 'D0##' format was used for Date (e.g. D004). From 15.1 version onwards, the following formats are used for Date:

  1. MM/dd/yyyy
  2. dd/MM/yyyy
  3. dd-MM-yyyy
  4. MM-dd-yyyy

The implementation teams that are migration to latest version of Canvas Technology from 14.1 or lower versions are instructed to perform the following tasks:

  1. Disable the framework provided formats by assigning the flag as false for isEnabled attribute.
  2. Create a new definition in the XML file for the previous Date format.


<?xml version="1.0" encoding="UTF-8"?>
<canvas-formats type = "date">
	<format 
		Id = "dd-MM-yyyy" 
		description = "dd-MM-yyyy" 
		javaDateFormat = "dd-MM-yyyy" 
		canOverride = "true" 
		isEnabled = "false"
	/>

	<format 
		Id = "MM-dd-yyyy" 
		description = "MM-dd-yyyy" 
		javaDateFormat = "MM-dd-yyyy" 
		canOverride = "true" 
		isEnabled = "false"
	/>

	<format 
		Id = "yyyy/MM/dd" 
		description = "yyyy/MM/dd" 
		javaDateFormat = "yyyy/MM/dd" 
		canOverride = "true" 
		isEnabled = "false"
	/>

	<format 
		Id = "dd/MM/yyyy" 
		description = "dd/MM/yyyy" 
		javaDateFormat = "dd/MM/yyyy" 
		canOverride = "true" 
		isEnabled = "false"
	/>

	<format 
		Id = "D004" 
		description = "MM/dd/yyyy" 
		javaDateFormat = "MM/dd/yyyy" 
		formatter-class = "" 
		canOverride = "true" 
		isEnabled = "true"
	/>

	<format 
		Id = "D003" 
		description = "dd/MM/yyyy" 
		javaDateFormat = "dd/MM/yyyy" 
		formatter-class = "" 
		canOverride = "true"
		isEnabled = "true"
	/>

	<format 
		Id = "D013" 
		description = "dd-MM-yyyy" 
		javaDateFormat = "dd-MM-yyyy" 
		formatter-class = "" 
		canOverride = "true" 
		isEnabled = "true"
	/>

	<format 
		Id = "D002" 
		description = "MM-dd-yyyy"
		javaDateFormat = "MM-dd-yyyy"
		formatter-class = ""
		canOverride = "true"
		isEnabled = "true"
	/>

</canvas-formats>