validation date/time fails due to what???

[Ole Bergtun]

Hi guys:)

Quick and short question: got this date /time column with time and when i update it using my webpart it works nicely, but when user updates data using sharepoint form it fails

take notice to the period colon --> 00.:00  

the dropdown provides format 01.30 (using period), but that fails - if i manually enter 01:30 (using colon) it updates

Why is this happening? tips and help appreciated

[#2]

Lento: First say Hello, then pls give more info. Is that column calculated? Greets, Eva

[#3]

Also same Language (Land / Region)?

[#4]

Hi jens, strange thing is that when i create a site in let say norwegian this happens, but when i then change regional settings to english then it works...
If i create the site in english then everything works as expected.

My thinking is that either way it should work.

O

[#5]

Hi Eva, the column is an ordinairy date column with time.

O

[#6]

Hi Ole! I think it’s because of JavaScript. Go create a PowerApp on that instead of the default Form, while you can use some formulas like FormatDateTime(utcNow(), „hh.nn“) for your Time fields and all other fields in your app. It’s much easier und it’s the future. Greets, Eva :smiling_face_with_smiling_eyes:

[#7 · Accepted solution]

Hi, i don't have a fix - but a work around.

This works correct when i change the regional settings to english in such a way that the user was abel to alter or insert date and time without the validation stopping the update/insert.