The significance of being in the zone, time zone that is.

This is a post with respect to how combined date/time fields is handled in AX/Dynamics 365 for Operations (Dyn365FO). For more information on the type of date and time fields in AX visit the following link from docs.microsoft.com.

Date/time data and time zones

Dyn365FO stores combined date/time fields internally in the SQL database based on UTC time zone. Whenever the date is to be displayed to the user, an offset based on the user preferred time zone is applied and then shown to the user.

This preferred time zone is set in the following section in Dyn365FO.

System Administration-> Users -> Users

User Options

Options-> Preferences

Time Zone

An excellent post that take a deeper dive on the subject along with the X++ code is found in the below link

Working with utcDateTime Functionality in Dynamics AX 2012 – StoneRidge Software

 

-Hitesh Manglani

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s