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

In this Microsoft Access tutorial, I will show you how to convert an ISO 8601 date-time value into a usable format for Access. Learn to split the date and time components, handle time zones, and create calculated fields using functions like DateSerial, DateAdd, and string manipulation features.
Kenneth from Yantis, Texas (an Expert Student) asks: I import Amazon Kindle Data to get a list of books that I have. The fields for dates come in with all those numbers and such that are never needed. Is there a way of formatting that data to just show the proper date?
BECOME A MEMBER:
UA-cam: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
Convert ISO Date Time: 599cd.com/Conv...
PREREQUISITES:
ISO Date Format: 599cd.com/ISOD...
ISO Date Format: 599cd.com/ISO
Calculated Fields: 599cd.com/Calc...
String Functions: 599cd.com/Stri...
DateSerial: 599cd.com/Date...
DateAdd: 599cd.com/DateAdd
CLng Type Conversion: 599cd.com/Type...
IIF Function: 599cd.com/IIF
LINKS:
Kenneth's Question: 599cd.com/a?87728
UP NEXT:
Convert ISO Date Time, Part 2: 599cd.com/Conv...
RECOMMENDED COURSES:
Access Developer Courses: 599cd.com/Deve...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Mi...
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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 conversion, date-time formatting Access, split date-time Access, extracting date Access, time zone conversion Access, date serial function Access, string functions Access, left mid right functions Access, Access query date conversion, UTC to local time Access, advanced query design Access, calculated fields Access, querying date-time values Access.
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@Jojosmith342]

all thumbs up to the best teacher Richard Rost. thank you Richard for another valuable tutorial. Hope more subscribe

[@alializadeh8195]

Thanks

[@ronaldmodesett509]

where can Hyper snap available

[@johnclark851]

Okay, great video, good info...blah, blah, blah. The screen-capture-to-text-then-paste-into-an-Access-table - thats the good stuff there!

[@nickbroekhuizen8858]

Your mission will fail ... lol, I prefer and use dd-mm-yy .. pet hate the other way around ... sorry ... lol 🤣🤣

[@Shadow.Dragon]

Very interesting video, Richard! Many, many moons ago, I started using a date/time format (YYYYMMDD.HHMM) similar to 8601 in my personal correspondence, programming, etc. Mine was derived from the "Star Trek date" format. I wonder if the authors of the ISO 8601 document were ST fans? LOL!!!