>>I have a datetime field named scheduled. I would like to replace the contents of the field with the next time the clock is 9 a.m in the morning. So if the datetime were say 23/05/2006 10:36:42
>>I would like to replace the value with 24/05/2006 09:00:00.
>>
>>Can anybody help me please?
>>
>>Thanks
>
>NewDateTime = DateTimeField + (24*60*60)
>? DATETIME(YEAR(NewDateTime), MONTH(NewDateTime), DAY(NewDateTime),9,0,0)
>
>** or
>NewDateTime = TTOD(DateTimeField) + 1
>? DATETIME(YEAR(NewDateTime), MONTH(NewDateTime), DAY(NewDateTime),9,0,0)
>
I was thinking in the same lines, but then an easier solution "hit me in the head". :-)
?Datetime() -Seconds() + (33*60*60)
