Dataverse columns set to Time Zone Independent add 1 hour every time i change the time and save within Dataverse Edit after 3/12/23 2:00am i am US Eastern DST

(0) Share

Report

Posted on by DaleORL

i have two of my Dataverse Date Time columns set to Time Zone Independent.

if i set a date/time after 3/12/2023 2:00am an hour is added to the time everytime I change the time.

becomes this

this occurs in dataverse edit data or on submit form in powerapp canvas app.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @DaleORL, use User Local instead.

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

DaleORL 27 on at

Like (0)

Report

we have switched the column from local to time zone independent which cannot be switched again.

Was this reply helpful? Yes No

AhmedSalih

6,678 Moderator on at

Like (0)

Report

@DaleORL, You might need to delete the column and recreate it but I would recommend that you decide what type of data/time time zone configuration you need:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/behavior-format-date-time-field

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

DaleORL 27 on at

Like (1)

Report

based on the example of hotel check in at 3.... Time zone independent. but why is the hour jumping when i save during Daylight Savings time while the columns are set to time zone independent. that part I don't understand.

Was this reply helpful? Yes No