Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
MyDate = date()
? MyDate
2/1/03
DaysInMnth = Day(DateSerial(Year(MyDate), Month(MyDate) + 1, 0))
? DaysInMnth
28
MyDate = Date - 3
? Date
2/1/03
DaysInMnth = Day(DateSerial(Year(MyDate), Month(MyDate) + 1, 0))
? DaysInMnth
31
SELECT DISTINCT Count(tblHolidates.HoliName) AS NumDts
FROM tblHolidates
WHERE (((tblHolidates.HoliDate) Between DateSerial(Year([MyDt]),Month([MyDt]),1) And (DateSerial(Year([MyDt]),Month([MyDt])+1,1))))
WITH OWNERACCESS OPTION;