How can I round to the next month

[Guest]

If an employee's probation period ends between the 2nd and the 30th of a
month, he/she will be eligible for benefits the following month, how can I
create an expresssion that will calculate this? thank you

 

[Duane Hookom]

You might want to open a module and search Help on date functions. The
DatePart() is quite flexible as is Day().

 

[Michel Walsh]

Hi,


Can also use DateSerial where the arithmetic is automatically handled
correctly for you:


DateSerial( Year( Now ), Month( Now) + 1 , 1 )



will work fine EVEN in December, where Month(Now) will return 12, and 12+1
will become 1, adding 1 to the actual year, AUTOMATICALLY, without YOU
having to make complex test and corrections.


Hoping it may help,
Vanderghast, Access MVP