How can I round to the next month

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
You might want to open a module and search Help on date functions. The
DatePart() is quite flexible as is Day().
 
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
 
Back
Top