cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a new date column

Highlighted
Blue LED
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
Highlighted
DC Motor
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.
Image: https://us.v-cdn.net/6030933/uploads/editor/tq/jj55k6ai89mf.png

I hope this helps! 

Thank You,
Akshay
0 Kudos