Maximizing Connectivity & Productivity

Archive for May 10, 2012

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)

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