We are trying to create an Outlook meeting invitation that starts and ends in the user's timezone:
Office365Outlook.V4CalendarPostItem(
// users calendar
"Calendar",
// subject
"Site visit: " & Text(VisitDatePicker.SelectedDate , "dd/mm/yyyy ") & HourDropdown.Selected.Value & ":" & MinuteDropdown.Selected.Value & " @ " & varSiteLocation.ShortCode,
// meeting start time
DateAdd(VisitDatePicker.SelectedDate + Time(
Value(HourDropdown.Selected.Value),
Value(MinuteDropdown.Selected.Value),
0
), TimeZoneOffset(), Minutes)
,
// meeting end time
DateAdd(VisitDatePicker.SelectedDate + Time(
Value(HourDropdown.Selected.Value),
Value(MinuteDropdown.Selected.Value),
0
), 60 + TimeZoneOffset(), Minutes),
// timezone for the meeting
"(UTC) Coordinated Universal Time",
)
When we hover over the invite in Outlook we can see that the date and time is correct (from 10:00):
But when we open the invite we see the UTC date format:
How can we represent the date in the user's timezone? How is it possible to get the user's region to use it and not use UTC? We have users all over the world and it would be great if we could fetch the local user's timezone sting somewhere.
Thank you for your help.
