About dates in Business Central
When you work with dates and time zones in Business Central, the following list provides insights on what's good to know.
- Every Business Central user has a timezone specified on the page User Settings.
- When a user logs into Business Central for the first time, this timezone is set using settings from the browser.
- Business Central stores all
DateTime
fields as UTC and in the UI layer, we convert these fields to the timezone, specified by the user on the User Settings page. - Two users might see a timestamp differently, but the point-in-time is the same.
- The Time Zone field on the User Settings page is in the UI and as such is only known by the client. You can't set a time zone per user on the User Card page in Business Central.
- Web Services connections are running using the UTC timezone and all
DateTime
types transferred in OData include a time zone as well. - The places in Business Central, where you still see
Date
fields are there because these fields don’t represent a timestamp. Instead, they represent a date for financial reporting or similar. Date
fields are never converted per time zone; a date value stays as it was entered.- The user enters the posting date in the UI, which represents the date on which this line is posted in the journal.
- The date and time is always displayed as local time in Business Central. Local time is determined by the time zone regional settings used by your computer. You must always enter date and time as local time. When you enter date and time as local time, it's converted to UTC using the current settings for the time zone and daylight savings time.
Note
Issues can occur when the posting date field is defaulted in code using the Today
method or using a conversion from a DateTime
to Date
. This conversion uses the user's timezone. Based on the current settings, it is not possible to guess what the right date for a conversion like that is. Today UTC is used, which for businesses in the US and Australia will surface immediately.