You need to sign in to do that
Don't have an account?
mikeol
Formula field / Date calcuations
I'd like a formula that takes a supplied date and returns a date which
will be exactly 3 years - 1 day into the future, i.e. last day of a 3
year agreement. For example 1 Jan 2007 > 31 Dec 2010. In Excel I
can have date made of component day or month values of 0 or less but
still get a valid date, i.e. DATE(2007+3,1,1-1) which is DATE(2010,1,0)
and equals 31/12/2009.
Thanks for your help.
Thanks for your help.
Try this ...
DATE(YEAR(given_date-1)+3,MONTH(given_date-1),DAY(given_date-1))
... where "given_date" is replaced by your date field's API name.
Hope that's helpful. :)
-Matt
It's a beauty.