In this video I'll show you how to store and display dates that fall outside of the range of a Microsoft Access Date Field. This is necessary for dates BC/BCE, for dates very far in the past (the Founding of Rome, the dinosaur extinction, etc.) or the future. Great for historical events, anthropology, astronomy, etc.
LEVEL: Expert (IIF Function)
Dagbjart from Denmark (a Silver Member) asks: how can I store dates BC or BCE (Before the Common Era) in Access?
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video. I'll show you how to create a data entry form which will allow users who are used to typing in "10/31/2021" to still enter dates that way and have them converted to your new fields. Plus we'll display the new date type either 31 AUG 443 BCE or 8/31/443 BCE.
MEMBERS ONLY VIDEO:
• How to Handle BCE Date...
BECOME A MEMBER:
/ @599cd
LINKS:
Validation Rules: 599cd.com/ValidationRule
IIF Function: 599cd.com/IIF
MonthName Function: 599cd.com/MonthName
Concatenation: 599cd.com/Concatenation
Left Function: 599cd.com/Left
UCase Function: 599cd.com/UCase
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
FREE Access Beginner Level 1: 599cd.com/Free1
FREE Blank Customer Template: 599cd.com/FRL2
$1 Access Level 2: 599cd.com/1Dollar
TechHelp: 599cd.com/TechHelp
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Email Me: amicron@gmail.com
WHAT DOES LEVEL MEAN:
My Access classes are divided into multiple levels. BEGINNER requires little working knowledge of Access. EXPERT assumes you know relationships and how to use functions and action queries. ADVANCED users know macros and events. DEVELOPER uses SQL and/or VBA programming.
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, handling dates in BC in access, how to represent a BC date, very old dates, bc, ad, bc vs ad, b.c., a.d., bce dates, bc dates, ce dates, ad dates, anthropology, astronomy, historic events
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Негізгі бет How to Handle BCE Dates in Microsoft Access (Dates BCE/CE or BC/AD) Useful for Very Old Dates BC
Пікірлер