Function: DateAdd
DateAdd allows you to add a timespan to a date/time value.
It is most useful when you want to express a query in terms of a date/time relative to a date/time in the past such as when using the ProjectStartDate
Syntax
Code Block | ||
---|---|---|
| ||
DateAdd(date, timespan) |
Example
Code Block | ||
---|---|---|
| ||
CreatedAt >= DateAdd(ProjectStartDate('Project X'), '2 weeks') |