>Well, to tell you the truth, I thought Jim's formula was like this:
>
>NewDate = gomonth(OldDate,1) - day(OldDate)
>
>but, it was really like this:
>
>NewDate = gomonth(OldDate,1) - day(gomonth(OldDate,1))
>
>which I think will work...but he agreed with my comment that it wouldn't work for a few days of the year...so maybe I am missing something...
Joseph,
Now I jumped to conclusions. The old formula works fine for all dates that I have tested.