News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... Why is a date's fo...

Microsoft Dynamics 365 | Integration, Dataverse...

Answered

Why is a date's formatted value different than it's actual value

(0) Share

Report

Report

Posted on by MZ_980

95

When I create a new dataverse record, I see that the formatted time is different that the actual time when I take a look at the OData:

"scheduledend@OData.Community.Display.V1.FormattedValue": "2022-09-01",

"scheduledend@odata.type": "#DateTimeOffset",

"scheduledend": "2022-09-02T00:00:00Z",

How do I make the formatted date match the actual date value? I've tried the Convert Time Zone action, but I don't know what the appropriate source and destination time zones would be since this is a global app.

All responses Img

All responses (2)

Answers Img

Answers (1)

Suggested answer

Leco Lv on at

Like (1)

Report

RE: Why is a date's formatted value different than it's actual value

Hi partner,

refer link： Converting time zone in Power Automate - Power Automate | Microsoft Docs
Verified answer

Guido Preite 54,081 Super User 2024 Season 1 on at

Like (1)

Report

RE: Why is a date's formatted value different than it's actual value

because the date is always stored as UTC, but the formatted value is based on the current user time zone.

You will need to retrieve the time zone offset of the user retrieving the record.

hope it helps

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans