I have a DB with the date/time field in Sharepoint. In my Access form I have the same field which I need to have automatically enter the GMT Time based off of the computer time and location.
I have been able to create a auto entry for my current location by calculating now()-.0125 and changing the format to get it to show 1930Z (Still having issue with missing the first zero with times between 0000 and 0959) anyway I would like to give the same access form for users in a different time zone and have them be able to update the SP list with the correct GMT Time.
I could get around this by creating a new form for different timezone users and changing the now() statement but I would prefer to have it correct so any user can load the access form from the web without confusion. There is also the issue of daylight savings time as well since GMT time does not change.
Thanks
Sav