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.
LEARN MORE:
[ Ссылка ]
PRE-REQUISITES:
Calculated Fields: [ Ссылка ]
DateSerial: [ Ссылка ]
Year Month Day: [ Ссылка ]
LINKS:
ISO Dates: [ Ссылка ]
RECOMMENDED COURSES:
Access Expert 27: [ Ссылка ]
Access Expert 28: [ Ссылка ]
Access DateTime Seminar: [ Ссылка ]
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)
BECOME A MEMBER:
YouTube: [ Ссылка ]
or My Site: [ Ссылка ]
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: [ Ссылка ]
$1 Access Level 2: [ Ссылка ]
Donate to my Tip Jar: [ Ссылка ]
Get on my Mailing List: [ Ссылка ]
Contact Me: [ Ссылка ]
TechHelp: [ Ссылка ]
Consulting Help: [ Ссылка ]
Twitter: [ Ссылка ]
[ Ссылка ]
[ Ссылка ]
[ Ссылка ]
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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
![](https://i.ytimg.com/vi/xKM_vc01LRM/maxresdefault.jpg)