Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 729
RelativeDate
Description Obtains the date that occurs a specified number of days after or before another
date.
Syntax RelativeDate ( date, n )
Return value
Date. Returns the date that occurs n days after date if n is greater than 0.
Returns the date that occurs n days before date if n is less than 0.
Examples This expression returns 2005-02-10:
RelativeDate(2005-01-31, 10)
This expression returns 2005-01-21:
RelativeDate(2005-01-31, -10)
See also
DaysAfter
RelativeTime
Description Obtains a time that occurs a specified number of seconds after or before
another time within a 24-hour period.
Syntax RelativeTime ( time, n )
Return value
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.
Examples This expression returns 19:01:41:
RelativeTime(19:01:31, 10)
This expression returns 19:01:21:
RelativeTime(19:01:31, -10)
See also
SecondsAfter
Argument Description
date A date value
n An integer indicating the number of days
Argument Description
time A time value
n A long number of seconds