Announcements
Hi Experts,
I struggle with this regularly and happening right now in a flow. I have a table that has a "Date Only" field in Dataverse called Registration Date. I am running a flow right now to set this date and it is 8/1/2021 at 8:37 am Central Standard Time. I have an expression setup to set this date but it is setting to 7/31/2021 vs. 8/1/2021.
Hi @dpoggemann,
Is the Behaviour of the Date column set to User Local? The problem is that in your flow you're not including the time portion in the date formatter. Therefore it will be saved as midnight in UTC, then timezone converted due to the user local behavior setting, making it the previous day.
Try removing the formatter string from the expression so it uses the default "o" format which includes the time. Dataverse will take care of storing it correctly and the client apps will take care of the timezone and displaying correctly.
---Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Hi @ChrisPiasecki ,
That was it, thanks so much! I modified to
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 545 Most Valuable Professional
Haque 314
Kalathiya 234 Super User 2026 Season 1
