I am trying to calculate the difference between created date and now() in calculated column in SharePoint 2013 but i have issue with the time zones.
The servers are in Europe (UTC +2) and some of the user are in Singapore (UTC +8)
When i go to the list and check the list item created by the users, the created timestamp is 6 hours into the future(!). So when i calculate the difference between created date and now, i get a negative number.
I don't know where to start troubleshooting this.
Below is some relevant screen shots.
My User information -- language and region
The list item where the timestamp is into the future.
The output of the calculations