web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Inconsistent date valu...
Small and medium business | Business Central, N...
Unanswered

Inconsistent date values when pulling timezone-independent fields from Dataverse virtual table

(1) ShareShare
ReportReport
Posted on by SS-23091538-0
 

Hi,

I am facing inconsistency in date values while pulling data from a Dataverse table using a virtual table.


  • The field in the Dataverse table is defined as timezone-independent (so it should only return the date value).

  • For example:

    • If the datetime stored in Dataverse is 21/09/2025 11:59:59 AM, the virtual table returns the correct date: 21/09/2025.

    • But if the datetime stored in Dataverse is 21/09/2025 12:00:00 PM, the virtual table returns 22/09/2025 (the date is rounded up by 1 day). 

After testing multiple cases, I observed:


  • If the time part is in AM, the returned date is consistent.

  • If the time part is in PM, the returned date is shifted to the next day.
  • There is no impact of Time-Zone Configuration. 

I cannot change the field property in Dataverse because this table is synced from F&O HR via dual-write. 

My questions is:


  1. Is this rounding behavior (AM = same day, PM = next day) expected when Dataverse converts a datetime field to date in a virtual table, or is this a bug/limitation? 

Thanks in advance for clarification.

I have the same question (1)
  • SS-23091538-0 Profile Picture
    SS-23091538-0 on at
    Inconsistent date values when pulling timezone-independent fields from Dataverse virtual table
     
    Initially, I had the same understanding. Since the user settings in Business Central are set to UTC, I expected the date to match exactly with the value in the Dataverse entity.

    Based on this assumption, I ran several test cases. What I observed is that for times in the AM, Business Central retrieves the same date as stored in Dataverse. However, once the time shifts to PM, Business Central starts retrieving the next day’s date.

    My current assumption is that Business Central does not support datetime fields with a time zone–independent property. The purpose of time zone–independent fields in Dataverse is to focus on the date portion, not the exact time. Accordingly, Business Central only pulls the date portion from Dataverse's datetime field, and there's likely some translation logic that causes the date shift when the time is in the PM range.
  • Nimsara Jayathilaka. Profile Picture
    Nimsara Jayathilaka. 2,948 on at
    Inconsistent date values when pulling timezone-independent fields from Dataverse virtual table
     
    Hi
     
    Yes, the behavior you're observing—where Dataverse virtual tables return the correct date for AM times but shift by one day for PM times—is expected and stems from how Dataverse handles time zone-independent date fields.
    Dataverse stores all date and time values in UTC. When a field is set to Time zone independent, it stores the exact date and time without converting to the user's local time zone. However, when this data is retrieved and displayed, Dataverse applies the user's local time zone settings. If the time stored is near midnight UTC, the conversion can cause the date to shift to the previous or next day, depending on the user's time zone.
     
     
    Thanks
    Nimsara

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sumit Singh Profile Picture

Sumit Singh 3,165

#2
Sohail Ahmed Profile Picture

Sohail Ahmed 2,682 Super User 2025 Season 2

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,299

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans