Here is an easy way to determine the first day of the next month from today’s date using the DateAdd
and DateSerial
functions in MS Access. As an example, if today’s date is December 9, 2012, then this will result in January 1, 2013.
=DateSerial(Year(DateAdd("m",1,Now())),Month(DateAdd("m",1,Now())),1)