I have a issue with date time fields having the wrong date (y2k check) and I have to change the date back and not wack the time.

gomonth(,-1) will change the date portion just fine, but it will set the time to midnight 12:00:00 AM. Which sucks when the time clock is now screwed!

any ideas?

__Stephen