%DAYS (Number of Days)

%DAYS(number)

%DAYS converts a number into a duration that can be added to a date or timestamp value.

%DAYS can only follow the plus or minus sign in an addition or subtraction expression. The value before the plus or minus sign must be a date or timestamp. The result is a date or timestamp value with the appropriate number of days added or subtracted. For a date, the resulting value is in *ISO format.

For an example of date and time arithmetic operations, see Figure 1.

For more information, see Date Operations or Built-in Functions.