>>>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)
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 ;-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
