Struggle to Set Date Only Field in flow for Current Date

(1) Share

Report

Posted on by Drew Poggemann

9,287 Most Valuable Professional

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.

convertFromUtc(utcNow(),'Central Standard Time','MM/dd/yyyy')

Any idea what I am doing wrong here?

Thanks much,

Drew

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @ChrisPiasecki ,

That was it, thanks so much! I modified to
convertFromUtc(utcNow(),'Central Standard Time','MM/dd/yyyy hh:mm:ss')

and it worked perfectly. I even subtracted 13 hours from now to prove it would till work in the formula as a test and it did.

Thanks,

Drew

Was this reply helpful? Yes No
Verified answer

ChrisPiasecki 6,422 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No