Avatar of Dale Fye
Dale FyeFlag for United States of America

asked on 

Windows regional time setting

I'm trying to customize an Access application that stores appointment date/times in a SharePoint list.

Unfortunately, I've got users all over the US that are using this application.  What I want to happen is that when the user selects 10am, and then saves the record, the value that actually gets saved will be in GMT.  So I need a way to convert a local time to GMT.  I'm assuming that the best way to do this is via an api call or by capturing a registry setting.  Just not sure how to accomplish this.

I'll either use the forms Current event or a conversion function in a query to convert the saved date/time back to local time for display purposes
Microsoft AccessMicrosoft Office

Avatar of undefined
Last Comment
Nick67
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Avatar of als315
als315
Flag of Russian Federation image

Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

Here is full code and how to do. Just pick the right page at EE:

Convert PST time to GMT

/gustav
ASKER CERTIFIED SOLUTION
Avatar of Nick67
Nick67
Flag of Canada image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

ASKER

not abandoned, just side-tracked.  Will get back to you.
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

ASKER

Nick,

This worked like a charm.  Thanks

Don't know how I failed to close this sooner
Avatar of Nick67
Nick67
Flag of Canada image

No problem
Avatar of Nick67
Nick67
Flag of Canada image

No problem
Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo