Thanks that did it.
I was focusing on the dtot(time()) and not getting it to take.
Thanks again.
__Stephen
>Stephen,
>
>How about
>
ttDateTime = datetime()
>? dtot(gomonth(ttDateTime, -1)) + (ttDateTime - dtot(ttod(ttDateTime)))
>
>Cheers,
>
>Andrew
>
>>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