>>>>>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) && 33=24+9

>>
>>Yes, this is great, but If the DateTime value is stored in a field then you couldn't get SECONDS() so easily :-)
>>Imagine that the field contains:
>>01/01/2006 12:33:55, then your method will works only if it is executed at 12:33:55 ;-)
>
>What about this solution?

>?Dtot(ttod(yourfield))+(33*60*60)

GREAT :-)