You can change the company, subsidiary, and user settings to use a different date format than the default setting. You can select the formats to use when displaying abbreviated and full dates. The abbreviated date format appears on reports, forms, and data-entry pages. The long date format is used when forms or templates require a non-abbreviated date format. You can choose between U.S. or international formats for dates, but some date formats are only available in specific locales.
Regardless of which date formats you choose, when you click the Pick icon or link next to a date field, a calendar opens that you can use to select a date.
To change the date format, do one of the following:
- To change the company date settings, go to Setup > Company > General Preferences. To change the abbreviated date format, in the Date Format dropdown list, select a date format. To change the long date format, in the Long Date Format dropdown list, select a date format. Click Save.
- To change the user date settings, go to Home > Set Preferences. Under Formatting, in the Date Format dropdown list and Long Date Format dropdown list, select date formats. Click Save.
- To change the date settings for subsidiaries, go to Setup > Company > Classifications > Subsidiaries. Next to the subsidiary that you want to change the date format for, click Edit. Click the Preferences subtab. On the General subtab, in the Date Format dropdown list and Long Date Format dropdown list, select date formats. Click Save.
If you enter a date in the DD/MM/YYYY format or the MM/DD/YYYY format, but the month or day only consists of a single numeral, a zero will be added in front of the single numeral automatically.
After setting the value we need to change the overriding settings from the general preference to reflect the date format in the NetSuite.
