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?
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.
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