In Aconex, you can customize the date format displayed in various fields and columns by utilizing the online layout editor to apply a specific formatting mask. This allows you to standardize how dates appear across your project documentation.
Step-by-Step Guide to Changing Date Formats in Aconex
Modifying date formats in Aconex is done through the layout editor, which gives you control over how data is presented. Follow these steps to set your desired date format:
- Access the Online Layout Editor: Navigate to the section of Aconex where you manage layouts and forms. This is typically found in the administration or settings area for customizing document and form templates.
- Select the Date Field or Column: Within the online layout editor, locate the specific table or form containing the date field or column whose format you wish to change. Click on that date element to select it.
- Open Properties: With the date field or column selected, look for the Properties pane, usually located on the left side of the editor interface. Click on it to expand its options.
- Navigate to Data Formatting: Within the Properties pane, scroll down until you find the Data Formatting section.
- Enter the Formatting Mask: Inside the Data Formatting section, there will be an option labeled Formatting Mask. In this field, enter the specific date format you want to use. This mask tells Aconex exactly how to display the date.
- Save Your Changes: After entering the formatting mask, ensure you save the changes to the layout. The new date format will then be applied to the selected field or column.
Understanding Date Formatting Masks
A formatting mask is a string of characters that represents how a date should be displayed. Each character or combination of characters corresponds to a specific part of the date (e.g., day, month, year) or time. Using these masks gives you precise control over the output.
Common Date Formatting Mask Examples
Here are some frequently used formatting masks and their corresponding outputs, assuming the date is January 23, 2024, at 3:05 PM:
| Mask | Description | Example Output |
|---|---|---|
dd/MM/yyyy |
Day/Month/Year | 23/01/2024 |
MM-dd-yyyy |
Month-Day-Year | 01-23-2024 |
yyyy-MM-dd |
Year-Month-Day | 2024-01-23 |
dd-MMM-yyyy |
Day-Abbreviated Month-Year | 23-Jan-2024 |
yyyy/MM/dd HH:mm |
Year/Month/Day Hour:Minute (24-hour) | 2024/01/23 15:05 |
MM/dd/yyyy hh:mm tt |
Month/Day/Year Hour:Minute AM/PM (12-hour) | 01/23/2024 03:05 PM |
dd MMMM yyyy |
Day Full Month Year | 23 January 2024 |
Tips for Effective Date Formatting
- Consistency is Key: For clear communication and data analysis, maintain a consistent date format across all documents and forms within your Aconex projects.
- Review and Test: Always review your layout changes in the editor and then test them in the live Aconex environment. This ensures the date format displays exactly as intended.
- Consult Aconex Documentation: For a comprehensive list of all supported formatting mask characters and their specific meanings, refer to the official Oracle Aconex documentation or support resources.
