Hi, I have a table with a column that is set as DateTime using native DateTime.
if I save to it from a server/computer with the regional settings set to display 24 hours it will save to that field something like: "1/23/2021 16:20:38.668"
if I save to it from a server/computer with the regional settings set to display 12 hours it will save to that field something like: "1/23/2021 4:20:38.668"
They both display the same when just output the CurrentDateTime() to a label: "1/23/2021 4:20:38,668 PM"
(Edit: after changing the regional settings and restarting the server it display "1/23/2021 16:20:38,668 PM" so the problem is only the saving)
not sure if I am missing any setting on the webapp to make it work correctly regardless of the server setting.
Thank you,
Oscar