MS Access Formula To Determine First Day of Following Month

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)