How Dynamics 365 for Operations Handles Date/Time Fields and Time Zones

26 April 20181 min readHitesh Manglani

A quick note on how combined date/time fields work in AX / Dynamics 365 for Operations. For the full breakdown of date and time field types in AX, see Date/time data and time zones on docs.microsoft.com.

Dynamics 365 for Operations stores combined date/time fields internally in SQL as UTC. When a value is displayed to a user, an offset based on that user's preferred time zone is applied first.

The preference itself lives here:

System administration → Users → Users

User Options

Options → Preferences

Time Zone setting

For a deeper dive into the subject with X++ code, see Working with utcDateTime Functionality in Dynamics AX 2012 from StoneRidge Software.

Using RetailCdxSeedData to Auto-Map Custom Tables in the Retail Scheduler

The class runs whenever this option is triggered in Dynamics 365 for Operations: Retail and commerce → Headquarters setup → Retail scheduler → Initialize retai…

D365 F&OStore Master

"Cannot Create a Record in Global Address Book (DirPartyTable)" When Creating a New Store

Co-written with Vishal Kohli, based on a shared troubleshooting session. !Store Master When creating a new store in the Store Master in Dynamics 365 for Finance…

Stuck on a D365 Commerce issue?

If you need hands-on help with MPOS, CRT extensions, or a Retail deployment, get in touch — I still build these things.

Talk to me