How to Convert a Full ISO 8601 Date Time Value to Microsoft Access, Part 2

In this Microsoft Access tutorial, I will show you how to convert a full ISO 8601 date time value into an actual Access date time value. We'll cover the use of the mid function, time serial function, and managing time zone adjustments. This is part 2.

Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will walk through how to use an update query to add the UTC date time value back into the table. I will also show you how to create a VBA function for converting single dates, which can be used on forms or reports.

MEMBERS-ONLY EXTENDED CUT VIDEO:
https://youtu.be/XAOrch47b_U

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LEARN MORE:
Convert ISO Date Time 2: https://599cd.com/ConvertISODateTime2

PREREQUISITES:
Convert ISO Date Time, Part 1: https://599cd.com/ConvertISODateTime

LINKS:
Date Math: https://599cd.com/DateMath
Update Queries: https://599cd.com/UpdateQ

RECOMMENDED COURSES:
Guide to Functions Starts in Access Expert 25: https://599cd.com/ACX25

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: https://599cd.com/Free1
How to Use Access in 30 Minutes: https://599cd.com/30Minutes
$1 Access Level 2: https://599cd.com/1Dollar
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database,, ISO 8601 date-time conversion Access, DateSerial function Access, DateAdd function Access, split date and time Access, handling time zones Access, string manipulation Access, TimeSerial function Access, add datetime values Access, UTC conversion Access, adjusting time zones Access, calculated fields Access.

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

Видео How to Convert a Full ISO 8601 Date Time Value to Microsoft Access, Part 2 канала Computer Learning Zone