Calculation of dates
Is there a formula that will return a date after a certain number of months, years or days from a given date? For example, If the date entered is June 27, 2005 in Field 1, Field 2 will automatically show a date that is 1 year and 6 months from Field 1 which is December 27, 2016.
4 replies
-
Trigger on update Field1:
—-
Field2 := date(year(Field1) + 1, month(Field1) + 6, day(Field1))
—-
Leo
-
That worked- Thanks Leo. Is it possible to trigger an update of multiple fields (ex. Field 2, Field3 etc) from an update of Field1? Wjat I want to do is for Field 2 to show a date that is 1 year and 6 months from Field 1 and Field 3 to show a date that is 5 years from Field 1. Also, is it possible to show a specific color highlight for Field 2 if the current date is less than 2 months from the date indicated in Field 2?
-
That worked- Thanks Leo. Is it possible to trigger an update of multiple fields (ex. Field 2, Field3 etc) from an update of Field1? Wjat I want to do is for Field 2 to show a date that is 1 year and 6 months from Field 1 and Field 3 to show a date that is 5 years from Field 1. Also, is it possible to show a specific color highlight for Field 2 if the current date is less than 2 months from the date indicated in Field 2?
-
i figured out that i just needed to add a semi colon to separate 2 triggers
Content aside
- 6 yrs agoLast active
- 4Replies
- 4491Views