How to create a new date column

[pauline_tan]

I need to create a new date column(Estimate Lead Create Date) using an existing date column(Lead Expiration Date).
For example:
Estimate Lead Create Date = Lead Expiration Date - 30 (days)
Which function do I use to calculate this?
Thank you.

[Akshay1 · Accepted solution]

Hello Pauline,

In order to create a new date column that does a increment/decrement on an existing date column - You could use the DATEADD operation on the compute column function.

SYNTAX: DATEADD( @COLNAME@, INCREMENT/DECREMENT NUMBER, INTERVAL)

The interval can be days, years, months, hours etc.

In your case you would use this formula (Shown in image) to calculate your new date.


I hope this helps! 

Thank You,
Akshay