Century (Magic xpi 4.13)

Magic xpi allows the user to enter the year component of the date in a two-character mask (YY) as well as a four-character mask (YYYY). When the date is entered in a two-character mask, it may create ambiguity as the date can belong to any century. To overcome this ambiguity, Magic xpi provides the Century setting in the Magic.ini file.

This setting specifies the default century of the date used throughout the system.

The default value of this parameter is set to 1920 in Magic.ini file. So, if you enter a year in YY format within this century, you will get the correct result.

For example, according to the following scheme, using the example February 1, 2019:

American date format is MM/DD/YY, displays as 02/01/2019

European date format is DD/MM/YY, displays as 01/02/2019

Scandinavian date format is YY/MM/DD, displays as 2019/02/01

Buddhist date format is DD/MM/YY, displays as 01/02/2562 because the year is increased by 543.

To enter a year in YY format beyond this century, modify the default value of the Century property in the Magic.ini file.

For example, change the default century to 1930 in Magic.ini file.

According to the following scheme, using the example February 1, 2020:

American date format is MM/DD/YY, displays as 02/01/2020

European date format is DD/MM/YY, displays as 01/02/2020

Scandinavian date format is YY/MM/DD, displays as 2020/02/01

Buddhist date format is DD/MM/YY, displays as 01/02/2563 because the year is increased by 543.

Note: If you use the default Date function available in the Functions List, the correct date will be shown without editing the Century value in the Magic.ini file.

It is recommended to use year format as YYYY and not YY when working with Date values.

Valid Values: American, European, Scandinavian, Buddhist

Default: European

Default Century: 1920

Change Effective: After restart

Magic.ini name: Century