How to configure the Thai calendar in ADSelfService Plus

Objective

This article details how to configure ADSelfService Plus to display dates according to the Thai calendar format (Buddhist Era). This setting is useful for organizations in Thailand or when your domain controllers are set to the Thailand locale.

Prerequisite

Have administrative access to the ADSelfService Plus portal. Depending on the method you choose, you may also need direct access to the application database (PostgreSQL or Microsoft SQL) used by ADSelfService Plus.

Steps to enable the Thai calendar

You can enable Thai calendar support using either of the following two methods:

Method 1: Through the ADSelfService Plus portal

Log in to the ADSelfService Plus admin portal.
Navigate to the Support tab.
On the top-right corner of the Support page, click the More link next to the Create Log section.
On the System Parameters Configuration page, locate the USE_THAI_CALENDAR parameter in the list.
If the parameter exists, edit the Param Value to true, and click Save.
If the parameter does not exist, click the Add/Update button and fill in the details as follows:

Param Name: USE_THAI_CALENDAR
Param Value: true

Click Save to apply the configuration.

Method 2: Using a direct database query

Note: This method should be used only if you are comfortable with SQL queries and have made a complete database backup.

Connect to the database used by your ADSelfService Plus instance.
Run the following SQL query to check if the parameter already exists:

SELECT * FROM SystemParams WHERE param_name = 'USE_THAI_CALENDAR';

Based on the result:

If the query returns a result, update the existing parameter:

UPDATE systemparams set param_value = 'true' where param_name = 'USE_THAI_CALENDAR';

If the query returns no results, insert the new parameter:

INSERT INTO SystemParams (system_param_id, param_name, param_value) VALUES ((SELECT max(system_param_id) FROM SystemParams) + 1, 'USE_THAI_CALENDAR', 'true');