>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