Function reference
Obtains a datetime that occurs a specified number of seconds after or before another datetime.

RelativeDateTime ( datetime, n )

Argument Description
DataTime A datetime value
n A long number of seconds

Data type: DateTime
Returns the datetime that occurs n seconds after datetime if n is greater than 0. Returns the datetime that occurs n seconds before datetime if n is less than 0.

Example 1
This expression returns the datetime 24 hours ago. (2017-1-1 19:01:31)
RelativeDateTime( DateTime(‘2017-1-2 19:01:31’) , -86400)

Last modified: 29 May 2021


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