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

(0) Share

Report

Posted on by MZ_980

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 (2)

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,071 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