First Day of Month
By Richard Rost
6 months ago
Find the First Day of the Month in Microsoft Access
In this Microsoft Access tutorial, I will show you how to calculate the first day of the month for any given date. We'll also learn how to calculate the last day of that month, the first and last days of the previous month, and the following month.
Pre-Requisites
Recommended Courses
Usage
- D = Date() or any date you choose
- FirstDayMonth: DateSerial(Year(D), Month(D), 1)
- LastDayMonth: DateSerial(Year(D), Month(D) + 1, 0)
- FirstDayPrevMonth: DateSerial(Year(D), Month(D) - 1, 1)
- LastDayPrevMonth: DateSerial(Year(D), Month(D), 0)
- FirstDayNextMonth: DateSerial(Year(D), Month(D) + 1, 1)
- LastDayNextMonth: DateSerial(Year(D), Month(D) + 2, 0)

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 month, last day of the month, first day of previous month, last day of previous month, first day of next month, last day of next month, first day of month, last day of month
|