Maximizing Connectivity & Productivity

Dates in Access – First and Last Day

FirstDay: DateSerial(Year([Testdate]),Month([Testdate]),1)
LastDay: DateSerial(Year([Testdate]),Month([Testdate])+1,0)
PrevMth_FirstDay: DateSerial(Year([Testdate]),Month([Testdate])-1,1)
PrevMth_LastDay: DateSerial(Year([Testdate]),Month([Testdate]),0)
NextMth_FirstDay: DateSerial(Year([Testdate]),Month([Testdate])+1,1)
NextMth_LastDay: DateSerial(Year([Testdate]),Month([Testdate])+2,0)

Leave a Reply

You must be logged in to post a comment.

E-mail: info@netlogistix.com
Mississauga, ON, Canada 905.607.3500