Nicki -

The following will return the last day a given month, taking into
consideration leap years:

x = "02/2007"
? dateserial(year(x), month(x)+ 1, 0)
2/28/07

y = "02/2008"
? dateserial(year(y), month(y)+ 1, 0)
2/29/08

Bob

Nicki wrote:
Im trying to get a formula that will work out the the due date on an invoice
based on 30 days, end of month.
Im assuming it needs to be something along the lines of Invoice Date + 30 +
difference between the last day of the month and invoice date. i would like
it to work out the last day of the month for me if this is possible. Im new
to databases so please be gentle, im learning from a dummies guide

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200702/1