Convert Full ISO 8601 Date Time 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?

Prerequisites

• ISO Date Format
• ISO Date Format
• Calculated Fields
• String Functions
• DateSerial
• DateAdd
• CLng Type Conversion
• IIF Function

Links

• Kenneth's Question

Recommended Courses

• Access Developer Courses

Up Next

• Convert ISO Date Time, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, 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.