Time zones in D365

You should set the correct time zones. You can set time zones on three places: 1. User options 2. Legal entity 3. System administration > Data management > Configure data source > Excel > Regional settings