>Hi folks!
>
>The GOMONTH() function, as you may know, returns a date that is "n" months ahead of or behind the supplied date value. For example, GOMONTH(DATE(),12) will return 11/29/2000. This is good.
>
>Now, the value of DATETIME() is 11/29/1999 12:22:23 PM. GOMONTH(DATETIME(),12) returns 12/29/2000 (yes, a date and not a datetime). This is bad.
>
>If you have something that goes into effect at 12:00:00 PM on 11/29/1999, what would you do to automatically determine that it expires 11:59:59 AM on 11/29/2000?
>
>I came up with a way but it's klunky. Anybody have any ideas?
Nope! What you've probably done is extracted the time portion of the date, used GOMONTH(), then added the time back to the result. AFAIK, that's the only way to do it.
George
Ubi caritas et amor, deus ibi est