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?