First Day of Year
By Richard Rost
5 months ago
Find the First Day of the Year in Microsoft Access
In this Microsoft Access tutorial, I will show you how to calculate the first day of the year for any given date. We'll also learn how to calculate the last day of that year, the first and last days of the previous year, and the following year.
Pre-Requisites
Recommended Courses
Usage
- D = Date() or any date you choose
- FirstDayYear: DateSerial(Year(D), 1, 1)
- LastDayYear: DateSerial(Year(D), 12, 31)
- FirstDayPrevYear: DateSerial(Year(D) - 1, 1, 1)
- LastDayPrevYear: DateSerial(Year(D) - 1, 12, 31)
- FirstDayNextYear: DateSerial(Year(D) + 1, 1, 1)
- LastDayNextYear: DateSerial(Year(D) + 1, 12, 31)

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, #fasttips, first day of the year, last day of the year, first day of previous year, last day of previous year, first day of next year, last day of next year, first day of year, last day of year, First day of current year
|