How to create a new date column

How to create a new date column

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.

Labels (1)
0 Kudos
1 Reply

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.


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,
0 Kudos