Two ways to setup the Date format in Sage x3

By | February 7, 2024

In Sage ERP X3, the software offers flexibility in representing dates, allowing users to customize the date format to align with specific requirements. To determine the current date format being used in the application, you can use the Adonix calculator by pressing Ctrl+Alt+K  on any X3 screen and entering ‘GFMD’ click on Ok  from that you can see the date format of the X3  folder .

It is common for clients to have specific preferences for date formats, such as DD/MM/YYYY, MM/DD/YYYY, YYYY/DD/MM, or other variations, which apply to reports, transactions, inquiry screen filters, and various other interfaces. To complete this need, Sage X3 provides a convenient way to configure the date format according to the client’s requirements. Here’s how you can set up the date format in Sage X3:

If you wish to modify the date format, follow these steps:

Option 1 :

Date Format Setup in Sage X3:

  1. Navigation :

To configure the date format, start by navigating to the ‘Administration’ section in Sage X3. Under ‘Administration,’ select ‘Settings,’ and then choose ‘Locales.’

2. Locales Screen :

Upon entering the ‘Locales’ screen, you’ll find a list of various language options to choose from. It’s important to note that the date format configuration is based on the selected language.

Please refer below imag

3. Select Language :

Click on the ‘Edit’ option next to the language for which you want to configure the date format. This action will open a window with multiple settings, including date format, long date format, time format, and more. For this configuration, we’ll focus on the date format.

As shown in below image,

4. Date Format Configuration :

 In the language-specific configuration window, you’ll find a field labelled ‘Date Format.’ Here, you can input your preferred date format, such as ‘M/d/yyyy’ or ‘d/M/yyyy,’ as per your specific requirements . It’s important to note that ‘M’ should always be in uppercase, also you can set up it to any Single or multiple language from the above screen at same time.

5. Save Configuration  :

After setting the desired date format, click on the ‘Save’ button to save your configuration.

6. Verification :

To ensure that the date format has been successfully applied, you can check any inquiry screen or account balances screen within Sage X3. The date format you’ve configured will now be visible, making it easier for you to work with the software in a format that suits your needs.

 Option 2:

We have another blog written to change the date format in Sage X3 folder “Change date format of the current folder in Sage ERP X3” please refer the below link to follow the way available in  X3

 (https://www.greytrix.com/blogs/sagex3/2014/12/31/change-date-format-of-the-current-folder-in-sage-erp-x3/) , if it does not work in your case you can try the option. 1 given above as per your requirement.

By following these steps, you can easily change the date format in Sage X3 folder, ensuring that it aligns with your preferences and requirements, thus enhancing the usability and functionality of the software for your specific needs.

About Us
Greytrix – a globally recognized Premier Sage Gold Development Partner is a one-stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development and implementation expertise.

Greytrix caters to a wide range of Sage Enterprise Management (Sage X3) offerings – a Sage Business Cloud Solution. Our unique GUMU™ integrations include Sage Enterprise Management (Sage X3) for Sage CRMSalesforce.com and Magento eCommerce along with Implementation and Technical Support worldwide for Sage Enterprise Management (Sage X3). Currently we are Sage Enterprise Management Implementation Partner in East Africa, Middles East, Australia, Asia. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit for Sage Enterprise Management to Sage business partners, end users and Sage PSG worldwide.

Greytrix is a recognized Sage Rockstar ISV Partner for GUMU™ Sage Enterprise Management – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage Enterprise Management – Salesforce is a 5-star app listed on Salesforce AppExchange.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com. We will be glad to assist you.