BlueCollar works with every date format NetSuite offers. Pick whichever one you find easiest to read; all BlueCollar screens and reports will follow it. The setting only changes how dates are displayed, so switching formats never affects your data or calculations.
Each format comes in two styles:
Both styles work equally well; it is purely a matter of preference. The full list, shown with January 5, 2025 as the example date:
| Zero-padded format | Example | Non-zero-padded format | Example |
|---|---|---|---|
| MM/DD/YYYY | 01/05/2025 | M/D/YYYY | 1/5/2025 |
| DD/MM/YYYY | 05/01/2025 | D/M/YYYY | 5/1/2025 |
| YYYY/MM/DD | 2025/01/05 | YYYY/M/D | 2025/1/5 |
| YYYY-MM-DD | 2025-01-05 | YYYY-M-D | 2025-1-5 |
| DD-Mon-YYYY | 05-Jan-2025 | D-Mon-YYYY | 5-Jan-2025 |
| DD.MM.YYYY | 05.01.2025 | D.M.YYYY | 5.1.2025 |
| DD-MONTH-YYYY | 05-JANUARY-2025 | D-MONTH-YYYY | 5-JANUARY-2025 |
| DD MONTH, YYYY | 05 JANUARY, 2025 | D MONTH, YYYY | 5 JANUARY, 2025 |