Equation to output Date/Time based on number of days added

App Development
1

How do I set up an equation field that is a date/time output from when an X amount of days is added to a date/time field?

2

Hi Ryan-

The best way is to use the Date Utilities pipe. There is a specific API call to add days. It is quite easy to use.

DateUtilitiesPipe
DateUtilitiesPipe2560×1440 242 KB

Alternatively you can create an equation field and use the following expression.

ADDTIME({Date/Time Field}, 'X 0:00:00.00')

Change “X” to the number of days. If you want to change days and hours/mins/seconds you can change the “0:00:00.00” with hours, minutes, seconds, and milliseconds.

The “Date/Time Field” is the field you are using to pull the start date from in your Data Builder table.

Hope this helps,
Adam

1 Like