The addDays() function provides the ability to add or subtract days from a date.


addDays(date, integer)

Argument Description


An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date value).


The value to add to the date argument.  If the value provided is not an integer, it will be rounded to the nearest integer.

Where Available

Available in all places the injected expression icon is visible, as well as within Filter fields on Cards, Tables and List/View sections.


Where Example(s)
Business rules: Set Value

Attribute expression

addDays("2023-2-1", 3)

addDays("2023-2-1", 3.2)

both of the examples above would result in 2023-12-23 (i.e., 23 Dec 2023)

addDays(dueDate__c, -20)

Field Editability expression

Tab Visibility expression

Business rules: Condition

Stage_3_date__c < addDays(Stage_2_date__c, 30)
Business rules: Notification Subject

Business rules: Notification Body

Dynamic Filter

{!addDays(Stage_2_date__c, estimated_effort__c)}

{!addDays(due_date__c, -14)}

Embedded Section URL attribute

Business Rule: URL Call

External View URL on List/View

{!URL1__c & "/" & addDays(Program_Start_Date__c, -30)}
Metric expression sumif(Initiative__t, OPEX__m, active and due_date__c < addDays(start_date__c, 10))

sumif(Initiative__t, betweenDates(Revenue_Impact__m, Impact_Start_date__c, addDays(Impact_Start_date__c, 90)), Business_Unit__c="Alpha" and Phase__c=1)


Updated on January 29, 2024

Related Articles