Скачать или смотреть MS Access: End of month day/date function & leap year

Learn how to calculate the end of a month date or day from a date item and take care of leap year as well.
Check the video, where explained that how this smart attendance system is created from scratch:    • MS Access Database; Students Attendance us...  

Below is the SQL query syntax

SELECT IIf(DatePart("m",[Attendance]![Attendance Date])=2 And DatePart("yyyy",[Attendance]![Attendance Date]) Mod 4=0,29,DatePart("d",DateSerial(Year([Attendance]![Attendance Date]),Month([Attendance]![Attendance Date])+1,1)-1)) AS [Month Days], Max(Attendance.[Attendance Date]) AS [MaxOfAttendance Date]
FROM Attendance
GROUP BY IIf(DatePart("m",[Attendance]![Attendance Date])=2 And DatePart("yyyy",[Attendance]![Attendance Date]) Mod 4=0,29,DatePart("d",DateSerial(Year([Attendance]![Attendance Date]),Month([Attendance]![Attendance Date])+1,1)-1)), datepart("M",[Attendance]![Attendance Date]);