How to Handle BCE Dates
By Richard Rost 2 years ago
How to Handle BCE Dates in the Distant Past (BCE/CE or BC/AD)
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.
Dagbjart from Denmark (a Silver Member) asks: how can I store dates BC or BCE (Before the Common Era) in Access?
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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
Validation Rules: https://599cd.com/ValidationRule
Subscribe to How to Handle BCE Dates
Get notifications when this page is updated