Custom SQL fields - Command to extend date by X number (day, week, year)

What to use in Custom SQL field:

DATEADD(day,X,[Table: Field Date])

DATEADD(week,X,[Table: Field Date])

DATEADD(year,X,[Table: Field Date])

Example:

where

X = integer (1) e.g DATEADD(day,1,[Table: Field Date])

[Table: Field Date] = [Assignment: Scheduled End Date]