Sorry for the confusion.
At least we're all on top of this one now...the discussion has forced us the think about it....
Take care,
Joe
>>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.
Joseph C. Kempel
Systems Analyst/Programmer
JNC