You’re offline. This is a read only version of the page.
9,278
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.
Share
Report
All responses (
Answers (
