How to Determine Leap Years Using the IsDate Function in Microsoft Access

Показать описание

In this Microsoft Access tutorial, I will show you how to determine whether or not a year is a leap year using the IsDate function and a few other tricks.

BECOME A MEMBER:

LEARN MORE:

PRE-REQUISITES:

LINKS:

RECOMMENDED COURSES:

USAGE
D: CustomerSince
Y: Year(D)
D2: [Y] & "-02-29"
D2: "2/29/" & Y
IsLeapYear: IsDate([D2])
IsLeapYear: IsDate(Year([D]) & "-02-29")
IsLeapYear: IsDate("2/29/" & Year([D]))

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

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, leap year function, determine whether a year is a leap year or not, Code to calculate a leap year

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