Shop Floor Insight uses the Date Format setting on the Shop Floor Setup page to control how dates appear throughout the Shop Floor client.
Change the date format
- In Business Central, search for Shop Floor Setup.
- Go to the Client group.
- Click “Show More” in the Client group.
- In Date Format, enter the desired format.
- Close the setup page to save the change.
- Close and reopen the Shop Floor Insight browser or client on each workstation.
Common regional formats
The following examples use July 16, 2026:
| Region or style | Date Format | Example |
|---|---|---|
| United States | m/d/Y |
07/16/2026 |
| Canada, ISO-style | Y-m-d |
2026-07-16 |
| Canada, day-first | d/m/Y |
16/07/2026 |
| United Kingdom | d/m/Y |
16/07/2026 |
| Continental Europe | d.m.Y |
16.07.2026 |
| International ISO format | Y-m-d |
2026-07-16 |
| Written month | j M Y |
16 Jul 2026 |
| Written month and weekday | D, j M Y |
Thu, 16 Jul 2026 |
The format is case-sensitive. For example:
drepresents a two-digit day.mrepresents a two-digit month.Yrepresents a four-digit year.Mrepresents an abbreviated month name.Drepresents an abbreviated weekday name.
Supported date format specifiers
Date format specifiers are case-sensitive. For example, m represents a numeric month, while M represents an abbreviated month name.
Day and weekday specifiers
| Specifier | Description | Example |
d |
Day of the month with a leading zero | 01 through 31 |
D |
Abbreviated weekday name | Mon through Sun |
j |
Day of the month without a leading zero | 1 through 31 |
l |
Full weekday name | Sunday through Saturday |
N |
ISO-8601 weekday number | 1 for Monday through 7 for Sunday |
S |
English ordinal suffix, typically used with j |
st, nd, rd or th |
w |
Numeric weekday | 0 for Sunday through 6 for Saturday |
z |
Day number within the year, starting at zero | 0 through 364, or 365 in a leap year |
Examples:
| Format | Example result |
d |
16 |
D |
Thu |
j |
16 |
l |
Thursday |
jS |
16th |
l, jS F Y |
Thursday, 16th July 2026 |
Week specifier
| Specifier | Description | Example |
W |
ISO-8601 week number, with weeks beginning on Monday | 01 through 53 |
Example:
| Format | Example result |
W |
29 |
Y-\WW |
2026-W29 |
Month specifiers
| Specifier | Description | Example |
F |
Full month name | January through December |
m |
Numeric month with a leading zero | 01 through 12 |
M |
Abbreviated month name | Jan through Dec |
n |
Numeric month without a leading zero | 1 through 12 |
Examples:
| Format | Example result |
m |
07 |
n |
7 |
M |
Jul |
F |
July |
j M Y |
16 Jul 2026 |
F j, Y |
July 16, 2026 |
Year specifiers
| Specifier | Description | Example |
Y |
Four-digit year | 1999 or 2026 |
y |
Two-digit year | 99 or 26 |
Examples:
| Format | Example result |
Y |
2026 |
y |
26 |
d/m/Y |
16/07/2026 |
d/m/y |
16/07/26 |
Separators and text
Characters such as slashes, periods, hyphens, spaces and commas may be placed between the format specifiers.
Examples:
| Format | Example result |
m/d/Y |
07/16/2026 |
d.m.Y |
16.07.2026 |
Y-m-d |
2026-07-16 |
D j/M/y |
Thu 16/Jul/26 |
For the complete list of supported date and time format characters, see the Client section of the Shop Floor Setup page.
Still need help?
Ask other Business Central users in the Insight Works community, or send the details to the support team. Include the steps you took and any error message you saw.