Notifications
Announcements
Hi,
I have a date stored in a dataverse table. The column is formatted as a date. When I display this date in my powerapp, there is a one day difference between the two (e.g. date in Dataverse is 1/12/2023 and this date in the app is showing 1/11/2023). Any idea why this is happening?
Thanks and Happy New Year!
Most probably the formatting of the date in powerapps can be the issue, could you share screenshots for both, also include screenshots of the powerapps code that has been used.
Hello, @karimabdelrazek, Make sure that your Date Column in the Dataverse table has been set to Date Only or Time zone independent in the Time zone adjustment:
If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.
I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.
Visit my Blog: www.powerplatformplace.com
Most likely cause is that the date in dataverse is defined as user local. In a model driven app the local date will take the User's dataverse Personal setting for the Timezone and display it as per that. However, other interfaces may display it differently due to how they determine the users time zone, sometimes this off the device it is running on or the browser that it is running in. (easiest/most consistent is to try an not use user local unless you have to)
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/behavior-format-date-time-field#for-my-datetime-column-i-was-expecting-utclocal-and-i-am-seeing-the-opposite-value
THANK YOU!!! This issue has been PLAGUING me! For what it's worth, I only use "date only" data in my power queries, data tables, and power apps and I was still struggling with this issue until I changed all of the date settings in my tables to "time zone independent".
By the way, I registered an account here (been lurking for over a year) just so I could thank you. 🙂
@JulieLeahy , thank you. I am glad that you finally were able to solve your issue.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Kalathiya 372 Super User 2026 Season 1
WarrenBelz 303 Most Valuable Professional
MS.Ragavendar 238 Super User 2026 Season 1
