Grid Date Formats
Overview
Date columns in admin grids, such as Created on the Orders grid, can be shown in a shorter format. You pick the format column by column. A short date takes less room, so more columns fit on the screen.
This works in grids that have the Gear icon for editing columns, such as Orders, Quotes, Invoices, Credit Memos, Bills, Shipments, Accounts, Customers, Transactions and Statements.
Changing a Date Format
- Open the grid, for example the Orders grid.
- Click the Gear icon above the grid.
- Find the Date Format section, under Active Columns. It lists each date column shown in the grid.
- Pick a format for the column you want to change.
The grid updates right away.
The Date Format section only shows when the grid has at least one date column among its active columns. Add a date column first if you don't see it.
Available Formats
| Format | Example |
|---|---|
| Date and time | November 16, 2026 at 3:52:11 PM |
| Date | November 16, 2026 |
| Short date (MM/DD/YY) | 11/16/26 |
Columns that only hold a date, such as due dates, don't offer Date and time. They offer Date and Short date (MM/DD/YY).
The short date follows your browser's language settings. A US English browser shows 11/16/26. A browser set to UK English shows 16/11/26.
Dates are shown in your store's time zone, the same as before.
Where Your Choice Is Saved
- In this browser. Your choice is saved with the rest of the grid's column layout (which columns are shown and their order). Another browser or computer shows the default format.
- Per grid. A choice on the Orders grid doesn't change the Invoices grid.
- Per tab. Each grid tab has its own columns, so each tab has its own date formats. See Order Grid Tabs.
To go back to the default, pick the column's first format again (Date and time, or Date for date-only columns). Removing the column from the grid and adding it back also resets it.
Good to Know
- Nothing changes until you pick a format. Every date column keeps its usual format by default.
- Exports keep the grid's usual date format. The date format choice only changes what you see in the grid.
- A cell that holds more than one date, such as several due dates on a bill, keeps its usual format.
Updated about 1 hour ago
