Type Conversion Functions in Microsoft Access: CCur, CDate, CDbl, CDec, CInt, CLng, CStr, and More.

In this Microsoft Access tutorial I'm going to teach you how to take text from one field in your database and convert it to another format like a date using the built-in type conversion functions.

Charlotte from Raleigh, North Carolina (a Platinum Member) asks: I get a spreadsheet from one of my suppliers and dates are formatted as YYYYMMDD. After I import them into my database, they come in as text. How can I get them into a normal date field? If I try importing them into a date field, I get a "type conversion failure" error. Help!

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
Type Conversion: https://599cd.com/TypeConversion

PREREQUISITES:
Calculated Fields: https://599cd.com/Calculated
String Functions: https://599cd.com/StringFunctions
ISO Date Format: https://599cd.com/ISO

LINKS:
Null: https://599cd.com/Null
Microsoft Type Conversion Page: https://tinyurl.com/25z43kow
Update Queries: https://599cd.com/UpdateQ

RECOMMENDED COURSES:
Access Expert 26: https://599cd.com/ACX26

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:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Type Conversion Functions, CBool, CByte, CCur, CDate, CDbl, CDec, CInt, CLng, CSng, CStr, CVar, Left, Right, Mid, Format, Converting Data Types, Importing From Text File, Type Conversion Failure, convert text to date, convert text to number, fixing date/time import error, import spreadsheet

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.