Hi: Can any one please tell me how to i calculate the next month starting day and next month ending date. For example if this is january then i need the next month that is february starting day and february ending day. I need to calculate the date in that way given below, I mean without query. Below method is i use it to calculate the todays date and the end of the day.

MonthLastDay = Empty
dFirstDayNextMonth = DateSerial(CInt(Format(dCurrDate, "yyyy")), CInt(Format(dCurrDate, "mm")) + 1, 1)
MonthLastDay = DateAdd("d", -1, dFirstDayNextMonth)

Thanks,

that's gonna fail in december

http://support.microsoft.com/default...b;en-us;210604

my bad :blush:

i underestimated microsoft access again!

DateSerial(2006,13,1) does indeed generate 2007-01-01

sorry