Notifications
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 @ChrisPiasecki ,
That was it, thanks so much! I modified to
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.
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…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Kalathiya 428
WarrenBelz 374 Most Valuable Professional
MS.Ragavendar 333 Super User 2025 Season 2