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
Neil Lewis
IT R&D Manager
Velmore Ltd