Function reference
Obtains a time that occurs a specified number of seconds after or before another time within a 24-hour period.

RelativeTime ( time, n )

Argument Description
time A time value
n A long number of seconds

Data type: Time
Returns the time that occurs n seconds after time if n is greater than 0. Returns the time that occurs n seconds before time if n is less than 0. The maximum return value is 23:59:59.

Example 1
This expression returns 19:01:41
RelativeTime( Time(‘19:01:31’) , 10)

Example 2
This expression returns current system time – 10 seconds.
RelativeTime( Now() , -10)


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment