Today() or chosen date is patching to Dataverse with prior day's date??

(0) Share

Report

Posted on by Kosenurm

802

Hi there,

I have quite a simple patch statement which takes the date selected in a Date Picker, along with several other controls, and patches to a Dataverse table. The date they select in the date picker (which is say the 13/09/2021 in the app, is coming through to Dataverse table as 12/09/2021).

I am in the UK - is this something to do with timezones??

How can I fix it?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

OanaBoghici 54 on at

Like (1)

Report
Copy link

Link copied!

Yes, I can confirm it's all about timezones. You can check the environment and your user account for the timezone (and sync them) or just calculate the difference in Hours and use the DateAdd function.

Was this reply helpful? Yes No
Kosenurm 802 on at

Like (1)

Report
Copy link

Link copied!

Thanks, I just managed to fix it by changing the Dataverse column's Behaviour to "Auto" and IME mode to "Auto".

Seems to be OK now, thanks.
K.

Was this reply helpful? Yes No