# Infor LN Date Format: User, Language, Reports and Integrations

> Source: https://netray.co/erp-help/infor-ln-date-format-user-language-integration
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: ERP Help

## Short answer

In Infor LN the displayed date format is governed by the user's language and locale settings rather than one global switch. Change it in the user data and the language or regional settings, check the Web UI browser locale, and keep integrations on a fixed format such as ISO 8601 so display settings never affect the data.

## Kind

how-to

## System

infor-ln

## Erp

Infor LN

## Module

Tools / User Data / Languages / Integration

## Query

infor ln date format

## Alternate Queries

- change date format infor ln
- infor ln date format dd/mm/yyyy
- infor ln date format reports
- infor ln date conversion bod

## Applies To

Infor LN 10.x, Web UI and classic client. Exact session names vary by release; use the session search to confirm.

## Steps

### How to change a date format

**Items:**

- Identify the layer that is wrong: the user's LN settings, the language definition, the Web UI browser locale, or a report layout.
- Open the user data for the affected user in Tools and check the language and any date or regional settings assigned to the user.
- Check the language data in Tools for the date display convention tied to that language.
- In the Web UI check the browser language and regional settings, because the front end may format dates independently.
- For reports, open the report in the report designer and check whether the date is formatted by a field setting or by a hard-coded mask.
- Re-test with a new login, since many settings are read when the session starts.

## Sections

### Display versus stored value

**Body:**

LN stores dates and times as values and formats them for display. A date format change therefore never changes data, which is also why a wrong-looking date is almost always a display layer problem. Do not edit stored data to fix a format.

Be careful with date and time zone: LN holds UTC values for date-time fields and converts to the user's time zone for display, so a date can appear to shift a day when a user in another time zone views a late-evening timestamp.

### Reports and exports

**Body:**

Reports can override the display, either by a format mask or by building the date as text. If one report differs from the screen, the report is the cause. Exports to Excel carry the value and the formatting of the receiving application, so a day and month swap in Excel usually comes from Excel's regional settings.

### Integrations and BODs

**Body:**

Never exchange dates as locale-formatted text. BODs and APIs use ISO 8601 style values. If a partner system sends dd/mm/yyyy, convert at the boundary in the mapping and document the rule. The classic failure is 03/04 read as March 4 on one side and April 3 on the other.

**Code:**

- ISO 8601 date:      2026-04-03
ISO 8601 date-time: 2026-04-03T14:30:00Z

## Pitfalls

- Fixing a display problem by editing stored data.
- Assuming the Web UI follows the LN user setting when it follows the browser locale.
- Passing locale-formatted text through integrations.
- Ignoring the UTC conversion on date-time fields.

## Ai Angle

A grounded assistant can answer which date convention a given user, report or interface uses, and can spot an integration mapping that converts dates incorrectly. It reads configuration and logs, and any change to mappings still goes through your change control.

## Faq

### Is there one global date format setting in Infor LN?

**Answer:** No. The format depends on the user's language and locale settings, the Web UI browser, and report layouts. Check each layer in that order.

### Why do dates look different in Excel exports?

**Answer:** Excel applies its own regional settings to the exported value. The LN value is unchanged. Fix the Excel locale or export in ISO format.

### What format should integrations use?

**Answer:** Use ISO 8601 for dates and date-times, in UTC for timestamps, and convert at the boundary of any system that needs a local format.

### Does changing the format change existing data?

**Answer:** No, only the display. The stored value is the same before and after.

## Search terms

infor ln date format, change date format infor ln, infor ln language settings, infor ln user data date, infor ln regional settings, infor ln report date format, infor ln bod date, infor ln time zone

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json