How about this one? It doesn't matter what SET DATE settings are. goMonth(tdDate, 1) - day(goMonth(tdDate, 1)) Biju > > > >I haven't been around for a while...how about: > > > >? (date()+32) - day(date()+32) > > > >Bill > > Bill, I've been following this thread for quite a while and I have to say > that your method is most awesome! I tried it with every month and it worked > excellent. > > KUTGW