Difference in Datetime when saving to SharePoint list

Like (0) Share

Report

Posted on 11 Jan 2024 14:05:25 by ervinw

I collect Date and Time by DatePicker and Dropdowns:

When I save this to a SharePoint list:

Set(var_occurence;DateTimeValue(DatePicker2.SelectedDate +
Time(Value(drpHour.Selected.Value);Value(drpMinute.Selected.Value);0)));;

Patch(Oktatas_alkalom;Defaults(Oktatas_alkalom);{Title:"Teszt";Oktatas_azonosito:cbbEducation_3.Selected.'Azonosító ({Identifier})';Időpont:var_occurence});;

I have a total different result:

Do you have any idea, what can cause this issue; how to solve this?
Thank you, Ervin

All responses (5)

Answers (2)

WarrenBelz 149,183 Most Valuable Professional on 12 Jan 2024 at 09:11:55

Like (0)

Report

Re: Difference in Datetime when saving to SharePoint list

@ervinw ,

Exactly what I suspected - and Pacific is the most extreme as far as behind UTC. What you are seeing is actually correct as far as the SharePoint Server is concerned.
ervinw 83 on 12 Jan 2024 at 08:15:51

Like (0)

Report

Re: Difference in Datetime when saving to SharePoint list

Just found it, it was Pacific... :), not Hungarian
Verified answer

Hasrie 202 on 12 Jan 2024 at 08:15:02

Like (1)

Report

Re: Difference in Datetime when saving to SharePoint list

Hi @ervinw the regional setting is in the sharepoint, not under your user account. Check under the "Oktatas_alkalom" Sharepoint > Gear icon > Site Information > Site Settings > View All Site Setting > Regional Setting > Check under TimeZone and Region / Locale
ervinw 83 on 12 Jan 2024 at 08:07:35

Like (0)

Report

Re: Difference in Datetime when saving to SharePoint list

I don't know, I have only found my settings here:
https://myaccount.microsoft.com/settingsandprivacy/language
Which is Hungarian, similarly like DatePicker's local setting.

(If I store the date as Text, then it's fine.)
Verified answer

WarrenBelz 149,183 Most Valuable Professional on 12 Jan 2024 at 02:11:00

Like (1)

Report
Re: Difference in Datetime when saving to SharePoint list

Hi @ervinw ,

You can save yourself a Variable as below, but that is not your issue. Have you done a number of different date/times to see if there is a consistent difference (in time) between your selection and the result ? One item I noticed was that you are using European syntax, yet your SharePoint data format is mm/dd/yyyy which is only USA, so what are the Regional Settings on your SharePoint server ?

With( { _occurence; DateTimeValue( DatePicker2.SelectedDate + Time( Value(drpHour.Selected.Value); Value(drpMinute.Selected.Value); 0 ) ) }, Patch( Oktatas_alkalom; Defaults(Oktatas_alkalom); { Title: "Teszt"; Oktatas_azonosito: cbbEducation_3.Selected.'Azonosító ({Identifier})'; Időpont: _occurence } ) );;