searched the help without any luck...which function do i use to get the current system time?
TIME keywird will give you integer representation of system time, if you need it in Hour:Minute:second form then try -
Miles is correct if you only want the time of day - TIME will give you the number of seconds since last midnight. If you have a datetime field then you want NOW.
If you have a datetime field then you want NOW.
Unfortunately NOW on 9.1d (lmentioned in the original post) is not much more than a day dream...
thanks for the help guys....