I have a date and time field which captures the date of input automatically both from the PC and from the mobile app.
I have users from around the world and the time is captured in their local time - but I do not know what the time zone is (they are using whatever their global setting is). How do I get this date and time I captured to show in a consistent time zone - like UTC +0?
To compound this - any entry coming from mobile device always captures in UTC + 0 format no matter what time zone they re in.
Is there a way at least in Lists to show the time zone that was captured when the time was set? When I look at the time or extract to excel there is no time zone listed.
Does this make sense? It is easy to replicate is you have people in 2 different time zones.