Convert time to a set timezone

(0) Share

Report

Posted on by Germán

Hello:

I am having a simple issue, but I don't know if there's a way to configure this without flows

So, I built two dropdowns where the user will select an hour and minutes to host sessions. My issue is that we have users from different timezones, but whatever they choose, I would like to have that value converted to the equivalent in CET timezone in the dataverse table. Basically, this is the formula:

Set(
    _SessionDateTime, 
    DateTimeValue(Concatenate(Text(_dateSelected, DateTimeFormat.ShortDate), " ", sessionTimeHour.SelectedText.Value, ":", sessionTimeMinute.SelectedText.Value))
);

Any idea how this could be done?

Thank you in advance

Categories:

General Questions

All responses (1)

Answers (0)

Suggested answer

SaiRT14 1,334 on at

Like (0)

Report

Convert time to a set timezone

You can use the DateAdd function to apply the timezone offset. Assuming the users select time in their local timezone,

Set(
_SessionDateTime,
DateAdd(
DateTimeValue(
Concatenate(
Text(_dateSelected, DateTimeFormat.ShortDate),
" ",
sessionTimeHour.SelectedText.Value,
":",
sessionTimeMinute.SelectedText.Value
)
),
CETOffset(),
Minutes
)
);